Defines a query.
(ade_qrydefine joinop bggroups not_op condtype qrycond endgroups)
Returns a condition ID or nil.
| joinop | A joining operator: "and" or "or" or "" (none). If "" (none) is specified, the default joining operator is used (see ade_prefgetval). |
| bggroups | For grouping this condition with others in the query definition you are building. Use one or more open parentheses as needed, or "" (none). For example, "((". |
| not_op | The NOT operator, if needed: "not" or "" (none). |
| condtype | A condition type: "Location", "Property", "Data", or "SQL". |
| qrycond | A condition expression. Depends on the condition type. See Condition Expressions below. |
| endgroups | For grouping this condition with others in the query definition you are building. Use one or more close parentheses as needed, or "" (none). For example, "))". |
A query definition is composed of one or more conditions, each defined by a separate ade_qrydefine call. You can group conditions by supplying parentheses or empty strings to the bggroups or endgroups parameters as needed.
You must specify all six ade_qrydefine arguments.
Condition Expressions
The qrycond parameter requires a condition expression. Condition expressions are lists. What you include in the list depends on the condition type: Location, Property, Data, or SQL.
Location Expressions
Property Expressions
Data Expressions
SQL Expressions