Use this dialog box to create or modify a SQL condition, if you are familiar with SQL.
- History
-
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 SQL statements.
- 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 quotes.
- 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 message.
AutoCAD Map 3D supports standard SQL syntax as formally defined in the ANSI X3.135-1989 SQL standard.