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 - [email protected]
http://lists.freepascal.org/mailman/listinfo/fpc-pascal