Transaction control by myself

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sergio Bertolotti
Posts: 54
Joined: Tue 02 May 2006 12:03
Location: Italy

Transaction control by myself

Post by Sergio Bertolotti » Wed 23 May 2007 19:56

Dear Support,
I'm a register user of SDAC 4.x professional version.
Is it possible to control transaction by developer instead SDAC with AutoCommit property ?
I found a protected boolean property Autocommit with default a True.
I want control myself transaction by code with StartTransaction, Commit or Rollback.

Best regards.
Sergio Bertolotti

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 24 May 2007 08:20

The AutoCommit property is in the protected section and has no effect in SDAC.
You can freely use TMSConnection.StartTransaction, TMSConnection.Commit and so forth to control transactions.

Sergio Bertolotti
Posts: 54
Joined: Tue 02 May 2006 12:03
Location: Italy

Post by Sergio Bertolotti » Thu 24 May 2007 12:12

Dear Jackson,

many thank's for your answer.

Best regards.

Sergio Bertolotti

Post Reply