Ungroups a sequence of two or more query conditions.
(ade_qryungroup condition_id1 condition_id2)
Returns T or nil.
| condition_id1 | Condition ID of the first grouped condition (real). |
| condition_id2 | Condition ID of the last grouped condition (real). |
This function affects the current query.
A query definition consists of a sequence of query conditions. Within such a sequence, there can be subsequences that have been grouped by enclosing them in parentheses. Such groups may have been established when the query was first defined. See the bggroups and endgroups parameters of ade_qrydefine. Or they may have been established afterward by ade_qrygroup. However established, you can use ade_qryungroup to undo a group (remove its enclosing parentheses).
When you call ade_qryungroup, the condition you specify as the first of the group (condition_id1) must be a predecessor to the one you specify as the last (condition_id2). The function ungroups the first and the last and any conditions in between. For example, consider the following query definition, which is composed of conditions A, B, C, and D:
A AND (B OR C OR D)
The function call (ade_qryungroup IDofB IDofD) changes the query definition to
A AND B OR C OR D