-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, February 23, 2016 9:36 AM
To: firebird-support@yahoogroups.com
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

transaction.

> 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.