Deleting records if they have children records

[SkayyHH]

If i set in appgini the option "Deleting records if they have children records" users get a hint that there are dependent datasets and if the user really wants to delete (with "yes" / "no").

Here it would be great if the user can select whether the child entries should be also deleted or not.

This would be a good usability improvement.

[onoehring]

Hi,

I like the idea - but of course it's somehow dangerous.

Also: If the developer has set some constraints in the database deletion might fail. AFAIK AG does not utilize the actual possibilities for constraints of the database (yet).

PS: Right now one would need to build such functionality by hand. For example, I am checking for certain subtables - if there are some records, I deny deletion, other subtables might have records from parent which do not stop deletion.

Olaf

[SkayyHH]

Thanks for your comments on this

Maybe it can be extended like this at some point in the future.