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 | Use |
and | where field1= “abc” and field2= “def” Used to connect multiple conditions or filters |
W E |
or | where field1= “abc” or field2= “def” Used to connect multiple conditions or filters |
W E |
checkbox | where field1 = “retail” checkbox “Retail” or “whole” checkbox “Wholesale” 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 | where date1 from “01-01-13” prompt “Begin Date” 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 | where date1 from “09-01-13” prompt “Begin Date” to “09-30-13” prompt “End Date” where date1 from ” “ prompt “Begin Date” to ” “ prompt “End Date” 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 | where table1.field1 via table2.field2 = “code” 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 case with |
The primary word that introduces the filter section. | W |
day | where date1 > “06-01-13” and date1 day > “15” 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 | where date1 >= “06-01-13” and date1 dayofWeek = “2” 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 | where date1 > “06-01-01” and date1 month = “6” 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 >