Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samsekar
Constraint Violating Yak Guru
437 Posts |
 Posted - 2002-01-30 : 02:09:29
|
Hi,I have a Table with a trigger on insert which does certain calculation on calling a procedure from the trigger.After the calculation the inserted record (that triggers) have to be updated as processed. It's not Happening!!!.One observation was that physical insertion into the table thro' query analyser is working fine.. but not happening thro' application!!!.Plzzzzzz help.Thanks Sekar |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-30 : 02:24:18
|
Samsekar, its pretty difficult to answer your question with the information you have provided. you can access the inserted record in a trigger this wayupdate s set s.colname=i.colname+3333 from tablename s inner join inserted ion s.pkey=i.pkeyquote:
After the calculation the inserted record (that triggers) have to be updated as processed. It's not Happening!!!.
i would suggest you to have a look at this Article by Grath on Triggershttp://www.sqlteam.com/item.asp?ItemID=6494--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
|
|
|
Problem with Trigger