Hello,
"can I do this in VFP?"
no, its also not very efficient to limit the resultset of queries on the clientside, e.g. Offset 2000, records 50, the client will retrieve the first 2000 records just to discard them -> unnecessary networktraffic & clientside processing.
The best solution is using Oracle itself to limit/paginate the resultset ->
http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.htmlRegards
Christian