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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 18:38:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.