Accuracer: The First And Only BDE Alternative
Client-Server Single-File Embedded Database for Delphi / C++Builder / Kylix
Introduction
The COMMIT statement is used to finish current transaction and write all changes to the database file.
NOFLUSH option specifies that file buffers should not be flushed after commit finished.
If this option is specified the COMMIT will work a little faster and all changes will be saved to the database file later, by separate OS process. If this option is not specified the COMMIT will save all changes to the database file and perform flusing of the file buffers, so after executing all data will be save to the database file.
For more information read Transactions topic in Developer's Guide.
Syntax
COMMIT [NOFLUSH]
Here is an example:
START TRANSACTION;
INSERT INTO Table1 (NAME) VALUES('aaa');
UPDATE Table2 SET Field1 = Field1 + 1;
INSERT INTO Table1 (NAME) VALUES('bb');
COMMIT NOFLUSH;
|