Hi!

My program processes data according to each records status. I take data with
status=1, do some stuff with it and set status=2. The transaction that is
tied to my Query has AutoCommit=true and Isolation=tiCommited. The
processing time for one record is less than 1 sec.

Query->SQL("SELECT ... from mytable where Status=1")

The method that is called in loop looks like:
Query->RefreshKeys();
Query->First();
....processing
Query->Edit();
Query("Status")->AsInterger=2;
Query->Post();


I had trouble with two users processing simultaniously. The data was
processed twice. I don't think that they succeeded to press button exatcly
the same second, probably I'm not using transactions correctly, so the one
users changes are not seen to another user.


Riho-Rene Ellermaa
senior programmer
Hansabank