Devart Forums

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

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.

Thanks, it helped