/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of FLUSH option in COMMIT statement.
  This SQL script contains 9 queries.
  Table "test" is  deleted, then recreated and filled with data.
  A transaction is started, data is inserted, then changes are comitted and immediately flushed to disk.
  At last you can see what data is contained in the table after all queries.*/

drop table MyTable;
create table MyTable (ID AutoInc, val1 Integer, val2 string(10));
insert into MyTable (val1, val2) values (2,'2');
insert into MyTable (val1, val2) values (4,'3');
start transaction;
insert into MyTable (val1, val2) values (5,'Flush1');
insert into MyTable (val1, val2) values (7,'Flush2');
commit flush;
select * from MyTable;