js editor
Web development
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.