Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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