Error while updating table from multiple chain of triggers -
07-10-2004
, 12:56 AM
Hi,
I am Using Powerbuilder 5 and sybase ASA 7.1.
I am getting strange error while updating table thru multiple
triggers. The scenario is
While inserting Invoice qty into Invoice table,
1. the trigger will update the DO table for DO bal qty and item master
table for os qty for invoice.
2. Update Trigger in DO table will update the Order table for order
bal qty and item master for os qty for DO.
3. Update trigger in order will update the item master for os order
qty.
Here i am getting unable to update Item master error, even each
trigger is updating different columns.
Please suggest where I made a mistake....
Thanks
-Satheesh chandra |