Re: Multiple changes, one transaction, with SQL

> If I perform multiple inserts/changes in one single SQL execution,
> (multiple instructions separated by semicolons), are they performed
> in a single transaction (if one fail, all fail)?

My apologies! I have just been informed by Per that the answer to this
question is... NO. Each individual statement inside the larger one is run in
its own transaction.

So, take note: To ensure data integrity using SQL and multiple statements
separated by ";", you should start a transaction first, then run a
multi-statement query, then commit or rollback as appropriate.

--

Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com

Eivind Bakkestuen [NDD] wrote:
....
> My apologies! I have just been informed by Per that the answer to this
> question is... NO. Each individual statement inside the larger one is run in
> its own transaction.
>
> So, take note: To ensure data integrity using SQL and multiple statements
> separated by ";", you should start a transaction first, then run a
> multi-statement query, then commit or rollback as appropriate.
>
>

I took note

Thanks Eivind

--
Hugo Galindo