Hi
A Datamodelling Tool allows for relation(ships) - if it's fully supportive - 4 actions to model for a relation(ship):
- Cascading Delete
- No Action
- Deny
- Nullify
With Servoy, Cascading delete, No Action, and Deny, can be implemented with the help of the 3 checkboxes available in the Options part of the relation.
But Nullify, which means: Set the foreign key column(s) to null if the record on the 1-side is deleted, doesn't exist in Servoy ( Servoy 4 is my reference).
My request is to add this functionality, i. e. to include, for example, a checkbox named Nullify (see Note 1). This would greatly reduce coding effort, as Nullify has to be done by JavaScipt coding right now. The relation already "knows" which column(s) are affected and could easely nullify the foreign key column(s) if this option is set.
Best regards, Robert
Note 1) I say checkbox as a quick and dirty solution for the current state (display) of these options. The reason for this statement is that I think the current grouping is not very well done, as it's a problem of OR's and AND's, how they can be applied. And the current checkboxes don't reflect that. Only a few combinations of the 3 checkboxes are useful.
I didn't think in depth about it but assume a better arrangement would be of checkboxes and radio buttons to reflect what is when useful.