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
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??
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
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

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

Current Time: Fri May 24 18:46:14 CDT 2024