Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2026-02

autostart transaction

2 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

duilio foschi

I am using Lazarus v. 3.4 32bit on windows 10.

I need to work with a Firebird db (old version v. 2.1).

I use the following components

   Conn: TIBConnection from unit IBConnection;
   Transaction: TSQLTransaction from unit SQLDB
   Query: TSQLQuery from unit SQLDB;

Is there a way to automatically start a transaction?

I see no AutoStartTransaction property.

In case a record is updated, is transaction automatically started by default?

Is a Transaction.StartTransaction command needed all the time in the code?

Please help

Thank you

Peppe

Reply by email

Michael Van Canneyt
to duilio foschi
duilio foschi wrote 17 lines
I am using Lazarus v. 3.4 32bit on windows 10. I need to work with a Firebird db (old version v. 2.1). I use the following components Conn: TIBConnection from unit IBConnection; Transaction: TSQLTransaction from unit SQLDB Query: TSQLQuery from unit SQLDB; Is there a way to automatically start a transaction? I see no AutoStartTransaction property. In case a record is updated, is transaction automatically started by default? Is a Transaction.StartTransaction command needed all the time in the code?

Depends.

if TSQLTransaction.Options does not include 'stoExplicitStart' then it should do the starttransaction automatically.

I don't recommend doing it automatically, but for simple cases it may work.

Michael.

Reply by email