SQL Expressions

AutoCAD Map 3D AutoLISP

Up a level
SQL Expressions
 
 

SQL expressions are used as querycond arguments in ade_querydefine calls that define SQL conditions.

They have the following format:

(linkpathname sqlcondition)

SQL Expression Parameters

linkpathname Link template (string).
sqlcondition SQL condition (string).

The sqlcondition argument should contain only the WHERE clause of an SQL statement (for example, "last_name = 'Smith'"). To select the entire table, let the sqlcondition argument be the empty string ("").

(ade_qrydefine 
    '("AND" "" "" "Sql"  
      ("EMPLN3" "") "" ) 
)