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" "") "" )
)