You can apply per object style settings for a mapped table. This syntax returns success or failure. The following syntax also works for the Set Map statement.
Server ConnectionNumber Create Map linked_table...
[ Style Type style_number [ Column column_name ] ]connectionNumber is an integer value that identifies the specific connection.
linked_table is the name of an open linked ODBC table
columnname is the name of the column containing the coordinates for the specified type
StyleType sets per-row symbology. style_number is a value either 0 or 1. The Column keyword and argument must be present when style_number is set to 1 (one). When the style_number is set to zero the Column keyword is ignored and the rendition columns in the MapCatalog are cleared.
Description
In order to succeed, the MapCatalog must have the structure to support styles. It must contain the columns RENDITIONTYPE, RENDITIONCOLUMN, and RENDITIONTABLE. The command should not succeed if the style columns are not character or varchar columns. The SQL statement itself will probably fail if it tries to set a string value into a column with a different data type.
Example
Server 2 Create Map For "qadb:sample.arc"
Type MICODE "mi_sql_micode" ("mi_sql_x","mi_sql_y")
CoordSys Earth Projection 1, 0 ObjectType Point Symbol (35,0,12) Style
Type 1 Column "mi_style" See Also:
Server_Connect( ) function, Set Map statement.