Subject Re: [firebird-support] firebird and transaction behaviour questions
Author Dimitry Sibiryakov
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?


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

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

Yes. See above.