Print Thread
Scrollable Query, First, Last and ReadBuffer
#9751 02/29/08 11:52 PM
Joined: Apr 2006
Posts: 10
M
Member
OP Offline
Member
M
Joined: Apr 2006
Posts: 10
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

Re: Scrollable Query, First, Last and ReadBuffer
#9752 03/03/08 03:59 PM
Joined: Aug 1999
Posts: 22,218
Member
Offline
Member
Joined: Aug 1999
Posts: 22,218
This seems like a bug. We'll check it out and will try to fix it.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 14 (0.008s) Memory: 2.4966 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-14 16:23:01 UTC
Valid HTML 5 and Valid CSS