pcsoft.us.windevCopyright 2026, PC SOFT22 Feb 2018 07:44:00 Z16 Feb 2018 09:10:00 ZHello, [WD22] [ using postgres now, should work with any database ] [ multi - tenant ] I need to delete a set of records which is having dependent child records also in the same file. Say TenantInd Code Name ParentCode 100 101 Name - 1 Null 100 102 Child - 11 101 100 103 Child - 111 102 100 104 Child - 1111 103 .... I need to delete records pertaining to TenantID = 100 only. Since this records are having FK integrity, it need to be deleted from the last child to first parent [ bottom up approach ? ]. Is there any simple way of deleting those records in Windev, that I need not go through writing cursors or something similar ? Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64695/read.awp22 Feb 2018 07:44:00 ZYes Yogi Yang, that's what I'm planning to do. I'll try that out and let u know. Happiness Always BKR Sivaprakashhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64695/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64695/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64647/read.awp21 Feb 2018 06:08:00 ZThanks Darren Farmer. This is what exactly I've. Need to study Treeview concept to change it to delete records. Thanks Fabric…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64647/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64647/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64646/read.awp20 Feb 2018 19:08:00 ZHi this is how I manage this kind of problem: I put the first record ID in an array I start a loop on the array for each l…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64646/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64646/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64638/read.awp20 Feb 2018 16:56:00 ZHi, A while ago, Carlo Hermus posted this on the WinDev Solutions section of this forum. I found it very useful for traversin…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64638/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64638/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64633/read.awp20 Feb 2018 14:59:00 ZHi I would go by just foillowing the path what needs to be done. Find the last recoord. ( hreadseekfirst(......) Find it …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64633/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64633/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64632/read.awp20 Feb 2018 14:01:00 ZRuben, Yes ParentCode fields could be null. That's for records that have no parents. But those records can have child(ren), a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64632/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64632/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64631/read.awp20 Feb 2018 12:25:00 ZHi. I have seen that the ParentCode field can have Null values, so I think you can do it in two steps: 1) Assign the Null …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64631/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64631/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64630/read.awp20 Feb 2018 08:56:00 ZHello Sivaprakash, If I understand it right: Browse the master file. Make a query on the second file and if HnbRec(subFile…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64630/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64630/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64626/read.awp20 Feb 2018 07:49:00 ZThanks AI. Your logic will work only if only one level of child is there. Say if Code 103 got its own child, say 107, deletin…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64626/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64626/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64594/read.awp17 Feb 2018 19:42:00 ZHello Sivaprakash You could set a filter on the child files on the parent key and then HreadLast and use HreadPrevious to wor…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64594/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64594/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64591/read.awp17 Feb 2018 12:34:00 ZPaulo Oliveria, I need to delete a set of records which is having dependent child records also in the same file. In the ab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64591/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64591/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64588/read.awp16 Feb 2018 14:44:00 ZIf you use HF and the referential integrity is defined in the Analysis to delete the record in the member file just delete the r…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64588/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64579-wd22-deleting-all-child-dependent-records-multi-tenant-64588/read.awp[WD22] Deleting all child [dependent] records in a multi-tenant file