2011

■ Filling Queried Drawing Objects with a Hatch Pattern (page 1281)
■ Changing the Color of Blocks (page 1284)
■ Modifying a Property Alteration Definition (page 1285)
NOTE This functionality applies only to drawing objects. For information on
altering geospatial feature data, see
Editing Features Using the Data Table (page
712).
To alter retrieved drawing objects based on linked SQL data
1 In
Map Explorer (page 2068), 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 (page 1863), 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.
1270 | Chapter 8 Analyzing Data