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 >