WhereType Property
Visual Studio .NET 2003
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 CursorAdapter WhereType 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
Show: