Riho-Rene Ellermaa wrote:

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

> The method that is called in loop looks like:

This will also do it without setting BufferSyncronFlags !
(More safe, i think)


Query->RefreshKeys();
Query->First();

Query->InvalidateBookmark(Query->Query.Bookmark);

if (Query->Status==1) {
....processing
Query->Edit();
Query("Status")->AsInterger=2;
Query->Post();
}

Query->Next();



Harald