WhereType Property

Specifies the fields that the WHERE clause consists of when used for updating tables. When working with this property for regular cursors, use the CURSORSETPROP( ) and CURSORGETPROP( ) functions. Read/write.

Note

Setting WhereType for CursorAdapter objects 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.WhereType [= nValue]

Return Value

  • nValue
    Numeric data type. The following table lists the values for nValue.

    nValue Description

    1 or DB_KEY (from FOXPRO.H)

    Includes only the primary fields specified by the KeyFieldList property.

    2 or DB_KEYANDUPDATABLE (from FOXPRO.H)

    Includes the primary fields specified by the KeyFieldList property and any updatable fields.

    3 or DB_KEYANDMODIFIED (from FOXPRO.H)

    Includes the primary fields specified by the KeyFieldList property and other modified fields.

    4 or DB_KEYANDTIMESTAMP (from FOXPRO.H)

    Includes the primary fields specified by the KeyFieldList property and a comparison of time stamps.

Remarks

Applies To: CursorAdapter Class

For forced update and delete operations, CursorAdapter uses the value of 1 for the CursorAdapter WhereType property regardless of the actual setting. Otherwise, CursorAdapter respects user settings for WhereType.

See Also

Reference

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

Other Resources

Properties (Visual FoxPro)