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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Commit in a User Event

Status
Not open for further replies.

TheGreenOne

Programmer
Jan 11, 2003
56
US
In ASA 9, I have created a database User Event which calls a stored procedure, the event is triggered manually. The stored procedure has a loop which creates lots of new records. Within the loop it commits the changes. I read somewhere that if any error occurs in an event all changes are rolled back. It would not be possible to rollback if the stored procedure explicitly commits, would it? Could it be that commits are ignored when a stored procedure is call by an event?

All comments welcome, thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top