Subject RE: [firebird-support] firebird and transaction behaviour questions
Author Zoran
-----Original Message-----
Sent: Tuesday, February 23, 2016 9:36 AM
Subject: Re: [firebird-support] firebird and transaction behaviour questions

23.02.2016 15:02, heineferreira@... [firebird-support] wrote:
>> A friend of mine said that everything in firebird MUST be done inside a

> That's true, but according to ODBC specs driver should start transaction
automatically as needed.

>> Is this the case if you are doing reads only?

> Yes.

Why would you use transaction for select statements?

>> Is this the case if you are only inserting, updating or deleting ONE
record at a time?

> Yes. In this case transaction can be committed automatically according
to ODBC "autocommit" attribute..

No. For ONE row at the time you don't need a transaction. If you are
changing multiple rows, then you do need to wrap it into transaction.

>> I can understand if you are writing changes effecting multiple records.
>> Do you have to do transactions while doing DDL changes?

> Yes. See above.