1 (edited by v_pozidis 2022-04-27 21:03:08)

Topic: Question for Delete

Hi, in my small example i like to ask if there is a way to delete record from the tablegrid from the Form1, I get an ERROR MESSAGE  FOREIGN KEY  CONSTRAINT FAILD.
i understand it because there is a retationship between the tables , but if I still want to delete the record how can I do that, without loosing the datas from the other tables

Post's attachments

Attachment icon del.zip 328.67 kb, 63 downloads since 2022-04-27 

2 (edited by brian.zaballa 2022-04-28 07:16:20)

Re: Question for Delete

You can set the tele as orphan by setting their id_Customer to null, then proceed to deleting the Customer.
I just don't know to what are you going to do with that orphaned tele data. But here's one way of doing it.

Post's attachments

Attachment icon del2.zip 553.33 kb, 77 downloads since 2022-04-28 

brian

Re: Question for Delete

Thank you