Disconnecting from a remote database, Working with styles in dbms tables – Pitney Bowes MapInfo Professional User Manual
Page 192

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 displays to allow
you 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 Professional
values, or the values currently residing on the remote database.
Disconnecting from a Remote Database
Disconnecting from a remote database server is a simple operation.
To disconnect from a remote database server:
1. From the DBMS Toolbar, do one of the following:
• Click the Disconnect DBMS
tool.
• On the File menu, click Close DBMS Connection.
2. In the Close DBMS Connection dialog box, the Connection list displays all the open connections.
Select the connection(s) you want to close and click OK.
The selected connection(s) close.
You cannot disconnect if you have a live table open using the connection you are trying to close.
Note:
Working with Styles in DBMS Tables
A table may use one style for all objects within a table, or contain different styles for each row, called
per row styles (per row style is optional). There are two requirements for setting up per row styles:
• A row must exist in the DBMS table
• You must set up a map catalog entry to activate the row style.
Using Per Row Styles for DBMS Table Layers
Per Row Styles allows the use of different object styles on a remote database. You can modify the styles
of individual objects or groups of objects and save them to a DBMS table. To use Per Row Styles, the
DBMS table must be set up correctly, and your MapInfo_MapCatalog must have the appropriate structure:
• The MapInfo_MapCatalog must contain columns that support the use of styles. They are:
RENDITIONTYPE, RENDITIONCOLUMN, and RENDITIONTABLE.
• The map table itself must have a character column wide enough to store the complete style string.
Style strings vary in width. We recommend a minimum of 50 characters be provided. If you plan to
use custom symbols, which use much longer strings, allow 200 characters.
• The entry for the table in the MapInfo_MapCatalog must be set correctly. This means that the
RENDITIONTYPE is 1, and the RENDITIONCOLUMN contains the name of the column that will contain
the style string. This entry is set by EasyLoader if the MapInfo_MapCatalog contains the new columns,
or it may be set using the Make Table Mappable function.
Changing the Symbol Style in a Mappable DBMS Table
The Change DBMS Table Symbol menu option allows you to change the symbol attributes for the point
objects in a mappable DBMS table.
1. On the Table menu, point to Maintenance and click Change DBMS Table Symbol. Or, select the
Change Symbol tool.
2. In the Select DBMS Table dialog box, select a table. Only mappable DBMS tables display.
MapInfo Professional 12.5
192
Opening a DBMS Table in MapInfo Professional