functionality applies only to drawing objects.
Use this dialog box to
create or modify a SQL condition, if you are familiar with SQL.
To modify a condition
you used previously, select it from the list. The condition is copied
to the Enter SQL Condition area, where
you can modify it.
- Link Template
Select the link template
that specifies the table to use with this condition. The SQL condition tests
information linked from this table to the queried objects. Because
queries apply only to objects in active source drawing, this list displays
only link templates in your source drawings.
- Enter SQL Condition
To create a new condition,
enter it in the box.
SQL Condition Syntax
SQL has a strict grammatical
structure and syntax. Here are some rules to follow when you define
- Character values (data type CHAR) must
be enclosed in single quotation marks ('XXX').
- If the column has a data type of string
or data, enclose the column name in double quotes. If the column
has a numeric data type, do not enclose the column name in double
- Database values are case sensitive, but
field (column) names are not.
- Do not end each
statement with a semicolon (;) as in standard SQL syntax.
- For dates, use the format TIMESTAMP'YYYY-MM-DD
00:00:00'. For example: "DATE">TIMESTAMP'1993-06-20 11:24:00'
- Do not use AutoCAD Map 3D or
DOS wild cards such as * or ? as part of column values or names.
- Do not use SQL keywords as identifiers.
Examples of keywords are SQL commands and data types such as CHAR,
GROUP, SQL, TABLE, USER, SECTION, BY, and CURRENT. Examples of identifiers
are table and column names. For example, if you try to create a
table with a column name of CURRENT, AutoCAD Map 3D displays an error
AutoCAD Map 3D supports standard
SQL syntax as formally defined in the ANSI X3.135-1989 SQL standard.