WhereType Property

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