Page 1 of 1

ApplyUpdates without Commit

Posted: Thu 28 May 2009 19:02
by eao19
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.

Posted: Fri 29 May 2009 06:59
by Dimon
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.