Specifies the number of rows progressively fetched from the remote table result set. When handling this property for regular cursors, use the CURSORSETPROP( ) and CURSORGETPROP( ) functions. Read/write.
|Setting FetchSize applies only to CursorAdapter objects with ODBC or ADO data sources and overrides the property setting of a cursor when attached to a CursorAdapter object. That is, changing the settings on the cursor using CURSORSETPROP() has no effect.|
CursorAdapter.FetchSize [= nValue]
- Numeric data type. The nValue parameter has a default value of 100 rows. If nValue is -1, Visual FoxPro retrieves the complete result set, which is limited by the value of the MaxRecords property.
Applies To: CursorAdapter Class
FetchSize applies primarily for remote views and setting it does not affect local views. However, you can preset this property for local views that will be upsized.