How can I use AutoCommit property ?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

How can I use AutoCommit property ?

Post by Guest » Tue 02 May 2006 12:07

Hi all,
I'm an evaluate user of SDAC 3.70 for MS-SQL Server.
I download a trial version last week.
I find a property AutoCommit : Boolean in TCustomDADataSet wich commit automatically changes on MS Server SQL.
I press right button on component and with - MSQuery Editor - I set correctly SQL,SQLInsert,SQLUpdate,SQLDelete,SQLRefresh properties.
In this components I not found AutoCommit property in object inspector.
If I select Help file, Autocommit is marked with yellow square, but I have not found the meaning in the legenda.
What does it mean yellow square in this property ?
How can I use it ?
There is a docs that I can read for this ?

I create a simple project with a TMSConnection and TMSQuery components connected to my SQL-Server 2005 DB.
If in Delphi code, I include DBAccess unit and I insert a reference to my MSQuery1.AutoCommit, I obtain this compiler error message :

[Error] Unit1.pas(42): Undeclared identifier: 'AutoCommit'

I use MS-SQL Server 2005 Express Edition in Italian with service pack 1 on my notebook and Borland Delphi 7 professional in english with the last service pack.
My operating system is Microsoft windows XP professional service pack 2 in Italian with the last service pack.

Best regards.
Sergio Bertolotti

Posts: 7
Joined: Mon 27 Mar 2006 07:46

Post by bekturov » Tue 02 May 2006 12:21

is protected property, see Help

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

Post by Jackson » Wed 03 May 2006 13:32

By default in SDAC each update, insert or delete statement is automatically committed by database server. There is no need for AutoCommit property.
That is why this property is in protected section and you can not access it in SDAC.

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

Post by Sergio Bertolotti » Fri 05 May 2006 11:10

Hi Eugene,
all clear.
Many thank's for you explanation.
Best regards.
Sergio Bertolotti

Post Reply