Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help on triggers

Status
Not open for further replies.

singularity

Programmer
Jun 4, 2002
5
US
I need some input on this. I have an INSERT-trigger on an order table, but sometimes a record will be lost. I suspect that this is caused by the trigger causing an error, thereby rolling back the entire INSERT. But I can not find anything wrong with the SQL-code, and the values used in the INSERTs that fails are identical to the ones in those that go through.
The trigger is too long to paste in here, but can anyone give me any general tips on creating very large triggers, any pitfalls, etc.. Simply put, how can a trigger fail using the same parameters that work fine at other times.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top