where section reserved words
The following Quiz reserved words are used primarily in the where section of the Quiz pad.
W – the where section.
E – expressions. Both dictionary and in-line expressions.
P – print section of the big five.
C – chart section.
Synonyms
Examples
Reserved word | Description | ![]() |
and | ![]() Used to connect multiple conditions or filters |
W E |
or | ![]() Used to connect multiple conditions or filters |
W E |
checkbox | ![]() Used where you want to offer choices or options when the report prints. At the same time, you don’t want the person printing the report to have to know what the field variables have to be. A checkbox will display with the caption. In the above example, at print time Quiz will display checkboxes for “Retail” and “Wholesale”. For each one, if checked, the filter is included, otherwise ignored. |
W |
optional | ![]() Used with prompt and checkbox to set the default status of the Include checkbox at Quiz print time. If optional is added, the default status is un-checked. |
W |
prompt | ![]() ![]() Used for user prompt at Quiz print time. The captions “Begin Date” and “End Date” will label the fields to be entered. The default values will be “09-01-13″ and 09-30-13” on the first example and blank on the second. |
W |
via | ![]() Sometimes the link to table1 is ambiguous and can be reached by more than one path. The via word forces the relationship to use the path from table2. |
W P |
where![]() ![]() |
The primary word that introduces the filter section. | W |
day | ![]() day of month. The above will include all records starting from “06-02-13” and include only records from day 16 for each month. |
W E P |
dayofWeek | ![]() day of week. Sunday= 1, Saturday= 7. The above will include all records starting from “06-01-13” and include only records on Mondays. for each month. |
W E P |
month | ![]() month of year (1-12). The above will include all records starting from “06-02-11” and include only records for June of each year. |
W E P C |
Page 1 — Quiz words
Page 2 — Operators
Page 3 — Where words
Page 4 — Print words
Page 5 — Sort words
Page 6 — Chart words
Page 7 — Expression words
Page 8 — System words
Page 9 — Global words
Next – print words >