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]
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