Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Transactions over multiple SQL statements

Sun, Dec 3 2006 12:08 AM	Permanent Link
"Al Vas"	Hi, I want to run two SQL update statements on two different tables. Can I contain both of them in a transaction and only commit if both statements are successful? Thanks Alex
Mon, Dec 4 2006 5:01 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Alex, << I want to run two SQL update statements on two different tables. Can I contain both of them in a transaction and only commit if both statements are successful? >> Sure. It would be best to use a restricted transaction in such a case: http://www.elevatesoft.com/dbisam4d5_transactions.htm -- Tim Young Elevate Software www.elevatesoft.com
Mon, Dec 4 2006 6:03 PM	Permanent Link
"Al Vas"	Hi Tim, Is restricted transactions a V4 feature? We are still using 3.30. Alex "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:FF6705EF-2278-41C2-9289-873921C82CF1@news.elevatesoft.com... > Alex, > > << I want to run two SQL update statements on two different tables. Can I > contain both of them in a transaction and only commit if both statements > are successful? >> > > Sure. It would be best to use a restricted transaction in such a case: > > http://www.elevatesoft.com/dbisam4d5_transactions.htm > > -- > Tim Young > Elevate Software > www.elevatesoft.com >
Tue, Dec 5 2006 4:08 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Alex, << Is restricted transactions a V4 feature? We are still using 3.30. >> My apologies. Yes, it is a 4.x-only feature. With 3.x, you'll just have to use a full database-wide transaction. -- Tim Young Elevate Software www.elevatesoft.com