FetchAsNeeded Property

Specifies how records are fetched. When working with this property for regular cursors, use the CURSORSETPROP( ) and CURSORGETPROP( ) functions. Read/write.

Note

Setting FetchAsNeeded applies only to CursorAdapter objects with ODBC or ADO data sources, affects only the next opened cursor, 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.FetchAsNeeded [= lValue]

Return Value

  • lValue
    Logical data type. The following table lists the values for lValue.

    lValue

    Description

    True (.T.)

    Fetch records as needed.

    False (.F.)

    For CursorAdapter objects with ODBC and ADO data sources, the MaxRecords property determines the number of records fetched. For native and XML data sources, all records are fetched.

Remarks

Applies To: CursorAdapter Class

See Also

Reference

CursorAdapter Object Properties, Methods, and Events

CURSORGETPROP( ) Function

CURSORSETPROP( ) Function

MaxRecords Property

Other Resources

Properties (Visual FoxPro)