Hi

I am using ibo to do the following.

Select first 100 * from messages where status = 1
I open the query and iterate through the rows returned and I use a
second query (same transaction connection and session) to update the
status to 2

FTransaction.StartTransaction;
While not FQuery.Eof do
begin
...
update messages set status = 2 where ID = FQuery.Fieldbyname('ID')
FQuery2.Execute;
FQuery.Next;
end;
FTransaction.Commit;

This is a multithreaded application but Connection, queries, sessions
and transactions are NEVER shared among threads.

I get the following exception... sometimes.

"At end of Dataset"

Is this excepion someting to worry about? At the moment I just catch
the exception commit the work and move on.

Thanks in advance
William