Altering Object Properties Using Linked Data
Concept Procedure Quick Reference
 
 
 
NoteThis procedure applies only to drawing objects.

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 dialog box, load or create a query that retrieves the objects you want to alter.
  3. In the Define Query 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.

For more information on connecting to and using external databases, see External Databases (Object Data).