Home » Developer & Programmer » Forms » URGENT-FAIL UPDATE IN TRIGGER
URGENT-FAIL UPDATE IN TRIGGER [message #78960] Mon, 08 April 2002 03:05 Go to next message
Stupid
Messages: 8
Registered: November 2001
Junior Member
Dear all,

I want to update table B whenever insert a record in Table A. So , I try to use a trigger to perform this.
Update table B is a complicate procedure. When I insert record in table A, I call a procedure inside the trigger.
But, I found that when I insert 2 records in the same time, the trigger fail to update table B.
Can anyone tell me why and how to solve this problem??
THANKS A LOT !!
Re: URGENT-FAIL UPDATE IN TRIGGER [message #79019 is a reply to message #78960] Sun, 14 April 2002 21:46 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
i think u've written a statement level trigger.

try to give 'for each row' in the trigger statement and create the trigger again.. and check out..

hope this will solve ur problem

cheers
ram
Previous Topic: updating a null value
Next Topic: frequently getting the frequency incompatibility error
Goto Forum:
  


Current Time: Sun Aug 09 04:19:46 CDT 2020