Behaviour in on Delete on Success code section
@ZOHO Creator Support:
While developing an application where I needed to delete all associated child records when the user requested to delete the parent record, I deployed this command ...
delete from child_Table[ Name == input.Name ];
... where both parent and child Tables have the common field called Name.
However, initially I misplaced this command in the on Delete on Success code section (instead of the on Delete on Validate) section ... as a result ...
- the parent record was (obviously) still deleted
- the child records were not ... probably because input.Name no longer existed
... but what was strange was that the contents of the Name field in the associated child records was now altered to blank ... and no error message was displayed. Edited later: Not strange at all after reading binarysprinter's comments below
For the benefit of novice users I suggest that references to input.<fieldname> be flagged as errors when entered in the on Delete on Success section of the code.
Also, requests to delete records should not cause record fields to be altered instead. Edited later: Ignore this ... after reading binarysprinter's comments below, this is not what is happening.
Gaev
While developing an application where I needed to delete all associated child records when the user requested to delete the parent record, I deployed this command ...
delete from child_Table[ Name == input.Name ];
... where both parent and child Tables have the common field called Name.
However, initially I misplaced this command in the on Delete on Success code section (instead of the on Delete on Validate) section ... as a result ...
- the parent record was (obviously) still deleted
- the child records were not ... probably because input.Name no longer existed
... but what was strange was that the contents of the Name field in the associated child records was now altered to blank ... and no error message was displayed. Edited later: Not strange at all after reading binarysprinter's comments below
For the benefit of novice users I suggest that references to input.<fieldname> be flagged as errors when entered in the on Delete on Success section of the code.
Also, requests to delete records should not cause record fields to be altered instead. Edited later: Ignore this ... after reading binarysprinter's comments below, this is not what is happening.
Gaev