August Tip

UNSEEN OPTIONS FOR QUERY BUILDER  Any unseen option used in Query Builder must be typed into the correct white component box area after any other selections are made for that component area.   Any number of unseen options may be used at once.

VERB COMPONENT
COUNT	The COUNT verb is not one of the dropdown verbs, but can be entered as a value. This Unseen Verb gives a total count of records within a file.
FILE COMPONENT
DICT	When using LIST in the verb component, the unseen option DICT can be used together with a filename in File Component to view dictionaries (DICT STUDENTS)
ITEMS COMPONENT
SAMPLE n	List only n records (default is 10). SAMPLE 100 gives 100 records. A SAMPLE option can be typed directly into the white Items component box.
SELECT.ONLY	Used as an option in query to ensure an active select list is used. If a savedlist is not active the sentence will not be executed.
WHEN	Replaces the keyword WITH from an Items Component selection. Selects records as long as at least one of the values in the multivalued field meets the selection criteria. WHEN only displays the value(s) that meet the criteria.
UNLIKE	Unseen operator that works the same as LIKE, but will look for values that do not match the pattern. Example: [WITH STU.TYPE UNLIKE "...CED..."]
BETWEEN	Unseen operator that must have 2 values entered, and the values are inclusive. The example: [WITH TERM.START.DATE BETWEEN "07/01/05" "09/30/05"] would contain dates of 07/01/05, 09/30/05, and any date between that range.
SAVING UNIQUE	field_name Unseen option used with SELECT or SSELECT that will save a List under some other field name rather than the @ID. The other field name is usually a key to another file. [SAVING UNIQUE APPL.APPLICANT]
SORT COMPONENT
BY.EXP	Designed specifically for sorting multivalued fields, and will sort by treating each value as if it were a separate record. Sorts in ascending order.
BY.EXP.DSND	Same as BY.EXP, but sorts in descending order.
OUTPUT COMPONENT
DBL.SPC	To allow double spacing between each record, include this command at the end of your Output component box. *Only used when creating a screen or printed report.
COL.HDG	Changes the heading of a field, i.e. Add COL.HDG "Last" after the LAST.NAME field (LAST.NAME COL.HDG "Last") This option will change the column name from the dictionary assignment of 'Last Name' to 'Last' for the current query. *Only used when creating a screen or printed report.
FMT	Changes the format of a field, i.e., Add FMT "20L" after LAST.NAME field (LAST.NAME FMT "20L"). This option will change the column size from the dictionary assignment of 57L to the size 20L for the current query. *Only used when creating a screen or printed report.