end-of-file marker is not being updated regularly during query

[hanso]

Hi,

When inserting records in a table through a SQL query the end-of-file marker is moved to the end of the data only when the query succesfully terminates.

If there is an error during execution of the query I can see from the data size of the file that records have been inserted but querying the file (select *) yields 0 records.

When inspecting the file with the function executer yields "end-of-file marker encountered" stepping to the first record.

Is there any way to commit changes every 100 or 1000 records or so?

Thanks for any help.

Hans.

 

[Linda84]

An insert statement is an atomic operation, whether you insert 1 or 100,000 rows. If you attempt a large # of inserts with a single insert operation and it fails somewhere in the middle, it will rollback the inserts done up to that point.

If you want to commit along the way, you have to write your statement/code to do smaller sets of inserts. Linda
Pervasive Software Support