DQL Lexicon Typographical Conventions
Except as noted below, the typographical conventions used in this lexicon are the same as those used in the previous chapters. These conventions are explained in Chapter I, DQL Basics.
In the syntax diagrams, items enclosed in brackets [ ] may or may not be included in the statement. If they are included, the quotation marks and parentheses must appear where shown. When multiple items are separated by a vertical bar |, any one of them may be used. For example, in the syntax statement:
[named "UNIQUE RELATIONSHIP NAME" ]
[with ( selection criteria ) ] FIELDNAME ;|.
You can use either a TABLENAME or a RELATIONSHIP in the script statement. A "UNIQUE RELATIONSHIP NAME" can be included or not. If selection criteria are included in the statement, the criteria must be enclosed in parentheses. A FIELDNAME must be included at the end of the statement, followed by either a comma or semicolon.
In the syntax diagrams, the terms shown in lower case (any, named, and with) are DQL keywords. The words shown in upper case (FORMNAME, TABLENAME, RELATIONSHIP, UNIQUE RELATIONSHIP NAME, and FIELDNAME) are generic terms. In an actual script you replace such terms with specific data by typing in the actual database names or selecting the appropriate items from the Script Editor pick lists.
Most examples in this lexicon are based on the MEMBERS and RESERVATIONS tables, included in the Club ParaDEASE sample application.