Database Trigger (URGENT!!!)
From: Jvazquez <jvazqueNOjvSPAM_at_uacj.mx.invalid>
Date: Thu, 30 Sep 1999 12:47:58 -0700
Message-ID: <08335b66.62d7a444_at_usw-ex0108-057.remarq.com>
I want to update a register when deleting a register from the same table becouse it has a recursive relation ... The table has the following fields:
Code, Description, Qty, Child_Code (Where Child_Code is the recursive relation and Qty is the number of childs that the Code has).
So, when deleting a record I would have to decrease the Qty field of the parent record.
So far i have tried a AFTER_DELETE_ROW API trigger but an error like this one apears: "table SII.CGFONDOS_C is mutating, trigger/function may not see it", i can not obtain the Primary Key fields once they are deleted.
Date: Thu, 30 Sep 1999 12:47:58 -0700
Message-ID: <08335b66.62d7a444_at_usw-ex0108-057.remarq.com>
I want to update a register when deleting a register from the same table becouse it has a recursive relation ... The table has the following fields:
Code, Description, Qty, Child_Code (Where Child_Code is the recursive relation and Qty is the number of childs that the Code has).
So, when deleting a record I would have to decrease the Qty field of the parent record.
So far i have tried a AFTER_DELETE_ROW API trigger but an error like this one apears: "table SII.CGFONDOS_C is mutating, trigger/function may not see it", i can not obtain the Primary Key fields once they are deleted.
Thank's much for your help...
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!