Quiz — Reserved words


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.
  Pprint section of the big five.
  Cchart 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 >

Leave a Reply