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

SAP Sybase SQL Anywhere 16.0 » Context-Sensitive Help » MobiLink plug-in help » Mappings tab » Mappings: Details


Conflict Handling tab

The Conflict Handling tab lets you define what happens when a row is modified both in the consolidated database and on a remote database.

  • Conflict Detection   This option determines when a conflict is detected. The conflict resolution mechanism is only activated when a conflict is detected.

    Choose one of the following options from the dropdown list.

    • Row-based   A conflict is detected if the row has been updated on both the remote and the consolidated database since the last synchronization.

    • Column-based   A conflict is detected only if the same column has been updated for the row in both the remote and consolidated databases. Otherwise, only the uploaded column updates are applied. If a table has BLOB columns, row-based conflict detection is used instead.

  • Conflict Resolution   Choose one of the following options for conflict resolution from the dropdown list:

    • Consolidated   First in wins. Uploaded updates are rejected if they conflict.

    • Remote   Last in wins. Uploaded updates are always applied.

    • Timestamp   The newer change wins, using a TIMESTAMP column that you maintain. This TIMESTAMP column records the last time that the row was changed. It should exist in both the remote and consolidated tables and be included in the synchronization. To work, your remote and consolidated databases must use the same time zone (preferably UTC) and their clocks must be synchronized.

      • Timestamp column   Enter the TIMESTAMP column here.

    • Custom   Write your own resolve_conflict scripts instead of having them generated automatically. You can do this on the Events tab.