Pitney Bowes MapInfo Professional - Manual (Page 190)

1. On the Table menu, select Maintenance and then Unlink DBMS Table.
2. In the Unlink Table dialog box, select the name of the table to unlink and then click OK.
The specified table unlinks.
Saving a DBMS Table
You save changes to a MapInfo Professional linked or live table the same way you save a regular MapInfo
Professional table, with the Save Table menu option.
Saving a linked or live table saves the records on the remote database. Before MapInfo Professional
updates records from a linked or live table, it evaluates the records in a process called conflict resolution.
If MapInfo Professional finds conflicts between the data on the remote database and records in the linked
table, since the time of its download, the Resolve Conflicts dialog box displays. Use this dialog box to
resolve conflicts.
• For more information, see Saving Changes Made to a DBMS Table in the Help System.
Conflict Resolution when Multiple Users Access a Remote Table
Other users may change or delete records in a table on the remote database after it was downloaded
into MapInfo Professional. 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 displays. 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 Professional.
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 Professional
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 displays 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 displays. This box displays enough information
for you to decide which data values to use to update the row in question.
Default resolution Type of conflict
Use server value Value changed on server, local value unchanged
Use local value Value changed on server, local value changed
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.
MapInfo Professional 12.5 190
Opening a DBMS Table in MapInfo Professional