Hi Arthur,

ORACLE has not native support for LIMIT like as MySQL...
Python can use specific API of OCI (Oracle Call Interface) but VFP across ODBC no.

* is equal to TOP N
=CURSORSETPROP("MaxRecords",nRecords,0)
=SQLEXEC(...)

*or USE RemoteView with sets the same properties

* is equal to Limit M,N, where M is 1 at first 
=CURSORSETPROP("FetchSize",nRecords,0)
* Read the buffer and wait to any change (GO TO, SKIP,...)
=CURSORSETPROP("FetchASNeeded",.T.,0)
=SQLEXEC(...)

*or USE RemoteView with sets the same properties

MartinaJ

>I would like to process a relatively huge amount of data sequentially from Oracle without specific selection criteria. Python has a function called SelectLimit(sql, nlimit [, noffset]) that lets one select nlimit rows beginning at noffset, can I do this in VFP?