Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Creating SQL Remote systems » Update conflicts » Custom conflict resolution using a VERIFY clause


UPDATE statements with a VERIFY clause

An UPDATE statement with a VERIFY clause takes the following form:

UPDATE table-list 
SET column-name = expression, ... 
[ VERIFY (column-name, ...)
   VALUES ( expression, ...) ] 
[ WHERE search-condition ]
[ ORDER BY expression [ ASC | DESC ], ... ]

The VERIFY clause can be used only when the table-list parameter consists of a single table. It compares the values of specified columns to a set of expected values, which are the values that were present in the publisher database when the UPDATE statement was applied. When the VERIFY clause is specified, only one table can be updated at a time.

The VERIFY clause is useful only for single-row updates. However, a multi-row UPDATE statement executed on a database is replicated as a set of single-row UPDATE statements by the SQL Remote, so this imposes no constraints on client applications.

 See also