| wselect | Index Level | wsselect |
| Syntax | |
| Category | TCL |
| Type | Verb |
| Description |
a FlashBASIC simulation of the "sort" verb that additionally exploits b-tree indicies.
For instance: sort entity by name In this example, only one attribute is specified. If there happens to be an index defined on the attribute referenced by "name", the response is practically immediate, since it can fetch the pre-sorted b-tree for the requested list. If the sentence were to contain a more complex expression, such as in the case: sort entity by zip by name Again, assuming that indices are defined on both the "zip" and "name" field, Access processes the sentence as though the indices were not even there. In some rare and peculiar cases, "wsort" may be faster than the "sort" verb. In addition, Access does NOT use the indices if any wildcards ("^") or string-searching characters ("[" or "]") are present in the sentence. |
| Options | |
| See Also | wselect wsselect sort wlist |
| Example | wsort entity by zip by name with name "a]" |
| Warnings | |
| Compatibility | D3 7.0 AP |
| wselect | Index Level | wsselect |