To Alter Drawing Objects Using Linked Data

You can define a property alteration that modifies queried drawing objects based on data stored in a linked database.

To alter retrieved drawing objects based on linked SQL data

1. In Map Explorer, under Current Drawing, right-click Current Query, and then click Define.
2. In the Define Query Of Attached Drawings dialog box, load or create a query that retrieves the objects you want to alter.
3. In the Define Query Of Attached Drawings dialog box, click Alter Properties.
4. In the Set Property Alterations dialog box, under Select Property, select the property to change.

   For example, to modify the color of retrieved objects, select Color as the property to change.

5. Click SQL.
6. Select a link template.
7. Select the external database column whose value you want to use as a value in the expression.
8. Click OK.

   The SQL column and link template are displayed under Expression in the Set Property Alterations dialog box, preceded by an ampersand (&). The link template is preceded by an at (@) symbol, for example, &Diameter@PIPES.

   You can also enter the SQL data variable directly in the Expression box.

9. Click Add.

   The property alteration definition is added to the Current Property Alterations list.

   When you execute the query with Alter Properties selected, AutoCAD Map 3D changes the queried objects based on the value stored in the external database.