I see. But visual grid in Oracle Forms can scroll result set of any size in both directions without any restriction. I think that fetched data is swapped to local disk and in memory remains only fixed number of records. It's good idea for writing new component in DOA. For example...
I can't use TOracleQuery 'cos I use TDBGrid and command 'Last' executed when I scroll to last record in TDBGrid. How can I scroll in big result sets in both directions (up and down)?
I have table with 200 000 records in it. When I open the 'select' statement in TOracleDataSet and execute 'Last' command then after long time waiting the exception with 'Out of memory' message appears. What to do?