| total-on | Index Level | user exits, Access |
| Syntax |
'item-id' {'item-id' ...}
with adi operator "valuestring" {and|or with...} 'item-id' {'item-id' ...} with adi operator "valuestring" {and|or with...} |
| Category | Access |
| Type | Definition |
| Description |
discussion on the rules pertaining to string delimiters imposed by Access sentences.
The use of single or double quote marks depends on the nature of the Access sentence. For referencing values (data elements), the string should be enclosed in double quotes: list customers with name = "fred]" For referencing item-ids, the (item-id) string should be enclosed in single quotes: list customers '100''101''102' Spaces between item-id's are optional. Both item-id strings and value strings may be included in an Access statement: list customers '100''101''102' with contact = "[barney]" The above case shows when Pick enforces the rules about single quotes surrounding item-ids and double quotes surrounding value strings. The backslash (\) character may also be used as a string delimiter. This is useful when the string being searched for contains both single and double quotes. The previous narrative explains the "traditional" rules of enforcement of the use of quotes. In D3, certain exceptions to the rules are allowed. For instance, in the sentence: list entity 88971677 99171776 The single quotes that would ordinarily be required around the specific item-id's are no longer required, provided that there is no ambiguities in the Access sentence. Access attempts to locate the unresolved items in the Access sentence as specific item-id's in the target file, if they could not be resolved as attribute-defining items. This new set of rules simplifies the syntactical requirements for Access sentences, yet introduces new variables into the interpretation of Access sentences. For example, in the sentence: list md 'description' This requests the specific item-id 'description' from the md of the current account, and only shows that item. By contrast, the sentence: list md description displays the "description" attribute for every item in the current md, since "description" happens to be a valid attribute-defining item. |
| Options | |
| See Also | wildcards without with |
| Example | |
| Warnings | |
| Compatibility | D3 7.0 AP R83 |
| total-on | Index Level | user exits, Access |