Because the records in a linked table are from a remote database, it is possible that other users may have changed or deleted them on the remote database since the table 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.
When saving a linked table, if MapInfo Pro finds conflicts between the data on the remote database and any records in the linked table since it was downloaded, the Resolve Conflicts dialog box automatically appears. Use this dialog box to resolve conflicts as explained below.
This process will be invoked whenever an attempt to save a linked table detects a conflict in an update. The dialog box allows the user to choose which fields from the conflicting records will be used to update the database. Three instances of the record being updated must be considered:
- 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).
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.
The Resolve Conflicts dialog box will appear once for each conflicting record. At any point in this process, the user may choose to leave this interactive mode and have the rest of the conflicts resolved automatically. The user may choose to use all local values or all server values.
For each conflict found during a commit, the user will be presented with a modal dialog box. This box will display enough information for the user 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 |
Column
Shows the name of the column in the record that has data that 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, below.
Original DBMS
Original Server
Shows the original data as it appeared when extracted from the database or server. 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, below.
Current MapInfo
Shows the data as it appears in the MapInfo Pro table you are trying to update. The MapInfo Pro field will be blank if the record has been deleted from the MapInfo database or server. If the data from the MapInfo Pro 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 Current MapInfo field, below.
Current DBMS
Current Server
Shows data as it appears in the remote database or server at the time of the update. (Another user might have changed this data since it was downloaded into a MapInfo Pro table.) The Current field will be blank if the record has been deleted remotely, after being downloaded into a MapInfo table. If the current data from the remote database or server 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, below.
Current MapInfo
Check this box to update the remote database or server with the value from your MapInfo table. If the current record on the database, server, or the MapInfo Pro record was deleted, then this check box is not available. Instead, you must use the MapInfo or Current/Server button, below.
Current DBMS
Current Server
Check this box to retain the current value on the remote database or server. If the current record on the database, server, or the MapInfo record was deleted, then this check box is not available. Instead, you must use the MapInfo or Current/Server button, below.
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
DBMS button/Server button
This button selects all the current DBMS or server values. If the record you are trying to resolve was deleted from the MapInfo Pro database or server, selecting the Current button will ignore the deletion and retain the current record in the remote database or on the server. If the record you are trying to resolve was deleted, selecting the MapInfo button will insert the new record into the remote database or onto the server.
Column
Shows the full name of the column highlighted in the list box.
Original DBMS
Original Server
Shows the full value of the original data highlighted in the list box.
Current MapInfo
Shows the full value of the MapInfo data highlighted in the list box.
Current DBMS
Current Server
Shows the full value of the current remote database data highlighted in the list box.
Navigation Buttons
OK
Causes the selected values to be used for the update of this record.
Stop Commit
The Stop Commit button terminates the entire update. A second dialog box will pop up to confirm that this is what the user really wants.
Automatic
The Automatic button causes the interactive conflict resolution to end. A dialog box displays that allows you to select which of the automatic conflict-resolution modes will be used for the remainder of this update. You can select one of two automatic modes in the dialog box. You can accept MapInfo Pro values, or the values currently residing on the remote database or server.
Close Edit Linked Table Dialog Box
Use the Close Edited Linked Table dialog box to close a linked table when there are edits pending.
Save Changes to MapInfo Table
Save the edits only to the local MapInfo table.
Save Changes to DBMS Table
Save edits to DBMS table on the remoter database. Edits are also saved to the local MapInfo table.
Discard Changes
Discard the changes made to the table.