Other users may change or delete records in a table on the remote database after it was downloaded into MapInfo Pro. As a result, conflicts may exist between the data residing on the remote database and the new data that you want to upload to the remote database.
If there are changes to records in the original data source when saving a table back to a remote database, a Resolve Conflicts dialog box opens. A conflict exists when the original state of the record does not match the server state. This implies that another user has updated this database since it was extracted by MapInfo Pro.
In the Resolve Conflicts dialog box, you can choose the fields to use from the conflicting records to update the database with. There are three considerations when updating a record:
- The original server state of the record (the record as it appeared when initially extracted from the database).
- The current local state of the record (the record as it appears in the session of MapInfo Pro making the update, possibly after editing by the user).
- The current server state of the record (the record as it appears in the database at the time of the update).
The Resolve Conflicts dialog box opens once for each conflicting record. At any point in this process, you may choose to leave this interactive mode and have the rest of the conflicts resolved automatically. In that case, you can use all local values or all server values to resolve the conflicts in the records.
For each conflict found during a commit, a modal dialog box opens. This box displays enough information for you to decide which data values to use to update the row in question.
| Type of conflict | Default resolution |
|---|---|
|
Value changed on server, local value unchanged |
Use server value |
|
Value changed on server, local value changed |
Use local value |
The dialog box provides you with the following options:
Column
Shows the name of the column in the record that has data which is in conflict and needs to be resolved. If the column name is too long and does not fit into the list box, a truncated representation will be shown instead. Its full value displays in the Column field.
Original DBMS
Shows the original data as it appeared when extracted from the database. If the original data is too long and does not fit into the list box, a truncated representation will be shown instead. Its full value can be displayed in the Original field.
Current MapInfo Pro
Shows the data as it appears in the MapInfo Pro linked table you are trying to save. The MapInfo Pro field will be blank if the record has been deleted from the MapInfo Pro database. If the data from the MapInfo Pro linked table is too long and does not fit into the list box, a truncated representation will be shown instead. Its full value can be displayed in the MapInfo Pro field.
Current DBMS
Shows data as it appears in the remote database at the time of the update. (This data might have been changed by another user since it was downloaded into an MapInfo Pro linked table.) The Current field will be blank if the record has been deleted on the remote database, after being downloaded into an MapInfo Pro linked table. If the current data from the remote database is too long and does not fit into the list box, a truncated representation will be shown instead. Its full value can be displayed in the Current field.
Current MapInfo Pro
Select this check box to update the remote database with the value from the MapInfo Pro linked table. If the current record on the database or the MapInfo Pro record was deleted, then this check box is not available. Instead, you must use the MapInfo Pro or Current button.
Current DBMS
Select to retain the current value on the remote database. If the current record on the database or the MapInfo Pro record was deleted, then this check box is not available. Instead, you must use the MapInfo Pro or Current button.
MapInfo button
This button selects all the MapInfo Pro values. If the record you are trying to resolve was deleted from the MapInfo Pro database, selecting the MapInfo button will delete the record from the remote database. If the record you are trying to resolve was deleted from the remote database, selecting the MapInfo button will insert the new record into the remote database.
Current button
This button selects all the current DBMS values. If the record you are trying to resolve was deleted from the MapInfo Pro database, selecting the Current button will ignore the deletion and retain the current record in the remote database. If the record you are trying to resolve was deleted from the remote database, selecting the MapInfo button will insert the new record into the remote database.
Column
Shows the full name of the column highlighted in the list box.
Original DBMS
Shows the full value of the original data highlighted in the list box.
Current MapInfo
Shows the full value of the MapInfo Pro data highlighted in the list box.
Current DBMS
Shows the full value of the current remote database data highlighted in the list box.
Stop Commit
The Stop Commit button terminates the entire update. A second dialog box confirms that this is what you really want.
Automatic
The Automatic button causes the interactive conflict resolution to end. A dialog box opens to select the automatic conflict-resolution modes you want to use for the remainder of this update. You can select one two automatic modes from the dialog box. You can accept MapInfo Pro values, or the values currently residing on the remote database.