Greetings All,
Delphi 5.1
Still using Firebird 1.5.3
I have a SQL that wants to fetch 200000+ records for a certain date range.
So to limit the number of records pulled back to the interface I set the
TClientDataset PacketRecords to 1000. Which works great as it instantly
pulls the information back to the interface and starts processing the data
in a while loop as follows.
while not EOF do
begin
...
next;
end;
My problem is that it only processes this for the first 1000 and then exits
the loop, I thought that it should continue to pull the next 1000 until
there is no more data that meets the criteria.
Any idea what I might be doing wrong?
Any help appreciated.
Mike
_______________________________________________
Delphi-DB mailing list
Delphi-DB@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
