General fields cannot be used in the WHERE condition of an update statement. Change the WhereType property of the view (Error 1489)

  • Article

In the WHERE clause of a SQL update statement, expressions you use to enforce optimistic locking cannot include general fields. Use the WhereType view property (you can change it from the default KeyAndModified to Key) to remove general fields from the update WHERE clause.

For more information on the WhereType property, see CURSORGETPROP( ) or DBGETPROP( ).