Hi, Thomas.

Is there a way to populate my local recordset with just a few rows and then fetch the others only when needed? For example, a consumer table with 10000 rows in an Oracle Database, and a VFP client. I want to "navigate" through all the rows. In the initial fecth i bring 200 rows, and when I click the next button that will show me the 201st rows, the recordset (I think the recordset does this) brings 200 more rows, making the app "faster" ("smarter" would be better) and moving less rows through the network.

In the "OraOLEDB Features" from Oracle is an explanation of the Connection String Attibutes and one of them is:

FetchSize - specifies the size of the fetch array in rows.

That´s way I use FetchSize=200.

Thanks for helping! :)