Subject | Re: [firebird-support] firebird and transaction behaviour questions |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2016-02-23T14:36:29Z |
23.02.2016 15:02, heineferreira@... [firebird-support] wrote:
as needed.
"autocommit" attribute..
--
WBR, SD.
> 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.
> 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.Yes. See above.
> Do you have to do transactions while doing DDL changes?
--
WBR, SD.