2011

Specifying a Value
The operator and the value define the condition that the value in the table
must match. For example, if you select the operator < (less than) and enter a
value of 5, the condition retrieves all objects linked to records in which the
value in the table is less than five.
■ The value must match the data type of the column. For example, if the
column requires a name, enter a text string.
■ Enclose string values in single quotes. If the string contains a single
quotation mark, precede the single quotation mark with a single quotation
mark.
■ For dates, use the format TIMESTAMP'YYYY-MM-DD 00:00:00', for example
"Date" > TIMESTAMP`1990-05-30 11:45:00'
Troubleshooting
Because a SQL condition relies on the ability to connect to a data source, the
condition will not work if any part of the connection is broken:
■ The query must specify a valid link template.
■ The data source must be attached and connected.
■ The data source must be in the same directory as when you connected to
it. (You must not have moved it after connecting.)
■ Links must exist between drawing objects and records in the specified data
source.
Tell me more
Video
■ Show me how to run a query on a set of
attached DWG files.
Procedure
■ To retrieve drawing objects based on
linked SQL data (page 1253)
GIS Skills
■ Bring in a subset of features using a
query.
1252 | Chapter 8 Analyzing Data