How can I use AutoCommit property ?

Guest · 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 3.70.1.26 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

bekturov · Post by **bekturov** » Tue 02 May 2006 12:21

is protected property, see Help

Jackson · 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 · Post by **Sergio Bertolotti** » Fri 05 May 2006 11:10

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