[fpc-pascal] Problem with TSQLQuery

[Volker Zipfel]

Hi all,

i've got a problem while reading a huge database table with TSQLQuery. The 
program consumes all the memory and is then terminated by the kernel. I think 
all read table rows are buffered. Is there a way to disable or limit the size 
of the buffer?

Example: 
  FQuery.SQL.Add('select * from TEST');
  FQuery.Open;
  while not FQuery.EOF do begin
    s := FQuery.Fields[0].AsString;
    Inc(Count);
    FQuery.Next;
  end;
  FQuery.Close;