I just tried the following and was a little confused/surprised by the result:
FQuery.Scrollable := True;
FQuery.ReadBuffer := 10;
FQuery.Execute;
FQuery.Last;
iRows := FQuery.RowCount; // Result is 202
if not FQuery.EOF then begin
FQuery.First;
while not FQuery.EOF do begin
// do something with Record
FQuery.Next;
end;
// only 10 records are actually processed !!
end;
I figured I was doing something wrong ...
10g Database with a 10g client.
Thx.
Michael