ApplyUpdates without Commit

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
eao19
Posts: 1
Joined: Thu 28 May 2009 18:44

ApplyUpdates without Commit

Post by eao19 » Thu 28 May 2009 19:02

New to all of this and hoping someone can help me out.

I have a ButtonClick event handler with a single line of code:

MSQuery1.ApplyUpdates;


A user will enter text into a DBEdit box on my form then clicks the button and the values is stored in the database. The help files and searches of this forum say that a database component's Commit method must be called to commit the changes. Why does the single command above work and write the data without needing a Commit?

Thanks.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 29 May 2009 06:59

You need to call the Commit method to commit current transaction. If you don't use transactions obviously by calling the StartTransaction method, then implicit transaction is used and data are commited automatically.

Post Reply