JavaScript Editor js editor     Web development 



Main Page

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.

See Also



JavaScript Editor js editor     Web development 

©

©©