You can wrap a group of actions into a transcation - that way if one of them fails the db will roll back the changes for all actions preceding (and including) the one that failed.
> -----Original Message----- > From: Wilcox, Jamileh [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 11:34 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Tango & MSSQL questions > > > Hi guys. We're running Tango 2000 and MSSQL 2000 on Windows 2000 > Server. > > 1. Is there any check in Tango that confirms that a SQL insert/update > action has completed before the web app continues? I need to set up > some tafs that will be doing multiple inserts each into > multiple tables > with several indexes and I'd like to be sure that all actions are > completing correctly.* > > 2. Is there a way to capture SQL errors in Tango (I'd like to present > more user-friendly error messages than SQL hands back)? > > As always, many thanks for your time, attention and patience! > > *(I remember doing one app some time back where I had > problems because I > did an insert into one table, then searched for the generated > ID to make > an insert to the next table; the search would fail because Tango had > started the search before the database had finished the update. But I > can't find the app and don't remember what setup we were using then.) > > jamileh wilcox > Information Systems > OU Physicians > (405)271-4647 x54124 > [EMAIL PROTECTED] > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
