Page 1 of 1

Deleting records if they have children records

Posted: 2021-01-07 21:31
by 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.

Re: Deleting records if they have children records

Posted: 2021-01-08 08:37
by 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

Re: Deleting records if they have children records

Posted: 2021-01-09 00:06
by SkayyHH
Thanks for your comments on this :-)

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