Relationship Options

Classic Servoy
1

The manual says to never use option two ‘Allow deletion of parent records with related record’ in combination with ‘Delete child records’.
We have numerous relations where A is to B, A is to C, A is to D (three child tables to the parent A). The delete always fails with ‘noParentDeleteWithRelatedRecords’ if we check ‘Delete child records’. We have flipped the checkboxes so we ‘Allow deletion of parent records with related record’ and DO NOT check the third option. When we attempt to delete we now get ‘ORA: error, FARC_FA_FK violated, child record found’. Can’t win for nothing on these two options.

But, if we check both options (which I know we are not supposed to do!), Servoy deletes the child records from the three tables and the parent record which is what we want to do.

Question: Is the manual wrong? Is this a bug that needs to be reported? We are hesistant to go against what the manual is telling us NOT to do. Kind of confused!

Gary

2

I just checked the CRM example and found the following:

For most relations that are parent_to_child all three options are checked (going against what is stated in the manual as a warning?)
For the reverse of these same relations the second option “Allow the deletion of parent records with related records”.

Do we assume the manual is wrong or the mechanisms of this three functions have changed?

Gary

3

Could we have a confirmation on this?

I’m having troubles in deleting child records, and got really confused by the examples v.s. manual. Should we not check both options ‘allow parent delete when having related records’ and ‘delete related records’??