TOracleQuery scrollable and eof

[clivew]

Edit: OK - Switched to TOracleDataset and it all works
=================================================

I seem to have run into a problem.
I have a scrollable TOracleQuery result set.
I need to keep running through it in a loop to apply values
to items in an outer loop.
Unfortunately, after the first run through the loop and calling:
TOracleQuery.First;
eof remains TRUE so it does not go through the loop again.
What can/should I do?
In case it matters, the test query was only bringing back a single record.

Pseudo Code:

while not outerLoop.eof do begin
query.First;
while not query.eof do begin

query.next;
end;
outerLoop.next;
end;

Thanks,
Clive

 

[Marco Kalter]

We'll check it out. As a workaround you could use a counter to determine how many records are in the result set after the 1st loop.

 

[leo lam]

Have this bug been resolved yet?
I have the same issue. Query.first or Query.moveto(1) does not move back to the begining of the query when EOF is reached.