Out of memory in while loop

[LarsDima]

I open big table for looking all record.
OraTable.Open();
while not OraTable.Eof do
begin
{something action with record}
OraTable.Next();
end;
OraTable.Close();
Table get > 1.000.000 records. Is it possible to clear the buffer after each statement Next

[bork]

If you are not going to use the Prior method or connect TOraTable to VCL controls which can use this method then you can set the property UniDirectional = True and memory will contain as many records as it is defined in the FetchRows property.

[LarsDima]

Thanks, it helped