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: