1
I have two tables using Firedac Tfdtable and did the Master-Detail relationship between them which works well. In Forms I have two Dbgrids, one for each table , when deleting a record in Dbgrid Master I would like it to automatically erase the corresponding records in Dbgrid detail, with an delete warning before deleting, so that the user confirms his intention. How to do this delete validationand operation? I appreciate the help.
Andrey, thank you. I will study this proposal and prototype a template to evaluate how it works. I will then respond with the result.
– JRG
Andrey, finish the test. I put the settings described in the link above , I did step by step in a test form, but IT DID NOT WORK , because when trying to delete a record in Dbgrid Master, which had children returned the error [Firedac][Phys][Ora] ORA-0922: Integrity Cont (JRG.Depto_emp_fk) violated - Child record found. I also changed the property of the Fdqueryemp (Detail) Detailservercascade = true , but nothing has changed ! I appreciate if you can help me !
– JRG
Important : in this test I used Fdquery instead of Fdtable, even then it doesn’t work !
– JRG
I found that I had to configure the property Cacheupdates=True in both datasets. Now IT WORKED delete Scade between a Dbgrid Master and a Dbgrid Detail ! Andrey , thanks !
– JRG