pcsoft.us.windevCopyright 2026, PC SOFT6 Dec 2019 13:55:19 Z6 Dec 2019 03:02:59 ZHi, I made 4 databases A, B, C, D. Relation A 0,1 - 0,N with B // In B I put in the analysis that A can erase B Relation A 0,1 - 0,N with C // In C I put in the analysis that A can erase C Relation A 0,N - 0,1 with D // Here I have integrity problems to erase the data. Can you give me an example of how to proceed, when I delete A it deletes without problems B and C, but with D I have problems since the relationship is reversed and I need A to erase everything. The code would be this. IF YesNo(0,"Are you sure to delete the record?") = True THEN HReadSeekFirst(A,A_ID,TABLE_CONS_A.COL_A_ID) IF HFound = True THEN HDelete(A) // Here it deletes A, B, C without problems HReadSeekFirst(A,D_ID,TABLE_CONS_A.COL_D_ID) IF HFound = True THEN HDelete(D) // Here I have the problem since this reaction is A 0, N to 0.1 Info("The record was deleted successfully") END END END TableDisplay(TABLE_CONS_A,taReExecuteQuery) I am learning, I appreciate any help... Greetings from Argentina...30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)dan_dan477pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67475/read.awp6 Dec 2019 13:55:19 ZHi Guenter Predl. I want to delete the records related to A, not the entire database, apart from the integrity problem, I de…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67475/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67475/read.awpDelete All Datagpredlpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67473/read.awp6 Dec 2019 07:49:45 ZHi, you can disable integrity errors using HSetIntegrity(..) https://help.windev.com/en-US/?3044058&name=HSetIntegrity which …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67473/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67472-delete-all-data-67473/read.awpDelete All Data