Header file: MapQuery.h.

An SQL condition is used to select drawing objects based on nongraphic data that is stored in an external database.

An SQL condition contains a = 4) BSPSPopupOnMouseOver(event);;">join operator and an SQL WHERE condition. In addition, an SQL condition specifies an associated link path name, called a = 4) BSPSPopupOnMouseOver(event);;">link template, to the external database in which the data is stored, so that the drawing and its related records can be compared during query execution.

After you have created an SQL condition, add it to a query branch using the AcMapQueryBranch::AppendOperand, AcMapQueryBranch::InsertOperand, or AcMapQueryBranch::SubstituteOperand function. Since these functions make a copy of the AcMapSQLCondition object, you can release the SQL condition after adding it to the query branch.

After you define the query with the query branch, the query will select drawing objects whose related database record values meet the conditions of the SQL WHERE condition. For example, to select all drawing objects that represent pressure valves, you might create a SQL condition such as VALVE_TYPE = 'PRESSURE'. The WHERE keyword is always omitted from such a statement.

The AcMapSQLCondition class is derived from the AcMapQueryCondition class.

Do not subclass from this class.