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.
|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]
Numeric data type. The following table lists the values for nValue.
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.
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.