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.
Deleting records if they have children records
Re: Deleting records if they have children records
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
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
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Deleting records if they have children records
Thanks for your comments on this
Maybe it can be extended like this at some point in the future.
Maybe it can be extended like this at some point in the future.