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;
_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Reply via email to