Export (0) Print
Expand All
Expand Minimize

FetchSize Property

Visual Studio .NET 2003

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.

Note   Setting FetchSize for 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]

Property Values

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.

Remarks

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.

See Also

Properties | CursorAdapter Object Properties, Methods, and Events | CURSORGETPROP( ) Function | CURSORSETPROP( ) Function

Applies To: CursorAdapter Class

Show:
© 2014 Microsoft