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

SQL Anywhere 10.0.1 » MobiLink - Server Administration » Synchronization Events

upload_fetch table event Next Page

upload_fetch_column_conflict table event


Fetches rows from a synchronized table in the consolidated database for the purpose of column-level conflict detection.

Parameters

Parameter name for SQL scripts

Order

r.pk-column-1

1

......

r.pk-column-N

N

r.column-1

N + 1

...

...

r.column-M

N + M
Default action

None.

Remarks

The statement-based upload_fetch_column_conflict script fetches columns from a synchronized table for the purposes of conflict detection. It is a companion to the upload_update event.

This script only detects a conflict when two users update the same column. Different users can update the same row, as long as they don't update the same column, without generating a conflict.

For example, using the upload_fetch_column_conflict script, you could avoid detecting a conflict when one of your remote users updated the quant column of the ULOrder table, and another remote user updated the notes column for the same row. You would only detect a conflict if they both updated the quant column.

You can have only one upload_fetch or upload_fetch_column_conflict script for each table in the remote database.

This script may be ignored if none of the following scripts are defined: upload_new_row_insert, upload_old_row_insert, and resolve_conflict.

See also