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]

Property Values

  • 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

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

See Also

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

Applies To: CursorAdapter Class