Specifies the page heading for a report.
Syntax
PAGE HEADING [BREAK HEADING indicator] reportitem [:format:]
Parameters
| indicator | Indicator can be
OFF
Suppresses all break headings at the top of each new report page.
LEVEL n
Causes the break heading for break level n and below to be displayed at the top of each report page. N is a positive integer.
The default value is LEVEL 1 (i.e., all break headings are displayed at the top of each report page). |
| reportitem | Any valid expression. Complex expressions must be enclosed in parentheses. When you specify more than one expression, each must be separated from the next by at least one space. |
| format | A set of instructions defining the format for the associated reportitem. Format is enclosed in : (colons) and can consist of any valid combination of format options. |
Comments
The PAGE HEADING command causes a heading to be displayed at the top of every page of a report. It also controls the display of break headings at the top of each report page. Report items in this command can include individual data values only from the first record to be processed on the current report page.
See Also
BREAK (Reports)
How to Use The Report Generator
PAGE FOOTING
REPORT HEADING
Report Item Format Options
SORTED BY
Sorts the members of the set produced by the main command.
Syntax
SORTED BY «expression [ASCENDING|DESCENDING]»
Parameters
| expression | An expression that identifies a field to be used as a sort key. Complex expressions must be enclosed in parentheses. |
| ASCENDING or DESCENDING | Specifies how the sort on the associated key is to be performed.
ASCENDING (default)
Sorts in “alphabetical order” (A-Z, 0-9).
DESCENDING
Sorts in “reverse alphabetical order” (Z-A, 9-0). |
Comments
The sorting clause determines the order in which the selected records are to appear in the set. The fields to be used as sort keys (identified by each expression) must be part of the set produced by the main command.
If you omit the sorting clause, the software determines the order of the records.
Note: Existing result sets can also be sorted after selection – with the SORT command.
Example
list all Employees sorted by Department descending FirstName LastName
The preceding command lists all Employees by department (in descending order) and, within department, by first and last names (in ascending order).
report from Invoices
sorted by {$month(InvoiceDate)-5
where $month(InvoiceDate) >= 6,
$month(InvoiceDate)+7}
:
endreport
The preceding program fragment reports invoices in order by fiscal month, assuming that the fiscal year begins in June.
See Also
SORT
Changes or assigns a password to the current Zim user ID.
Syntax
PASSWORD newpassword [oldpassword]
Parameters
| newpassword | The new password, up to 18 characters. Any characters are valid (i.e., letters, digits, punctuation). $Null is also valid; its effect is to remove a password.
Can also be an expression. If necessary, the expression is converted to character format. Complex expressions must be enclosed in parentheses.
If the value given for newpassword is longer than 18 characters, only the first 18 characters are used. |
| oldpassword | The current password. When there is no current password, omit oldpassword, or use $Null.
Can also be an expression. If necessary, the expression is converted to character format. Complex expressions must be enclosed in parentheses.
If the value given for oldpassword is longer than 18 characters, only the first 18 characters are used. |
Comments
The new password takes effect immediately. To remove a password, use a value for newpassword that is $Null.
Password checking is case-sensitive. They must be changed during a read/write transaction because passwords are stored in encrypted form. An attempt to change a password during a read-only transaction fails.
Example
Transaction (Explicit Read Write transaction)
password “$moreprofits” “$profits”
Changes the current user’s password from $profits to $moreprofits.
See Also
Data Types
Case Sensitivity
LOGIN
UNRELATED
In a set specification, selects non-matching members of an EntitySet, a relationship with fields, an application document, or a result set.
Syntax
object (UNRELATED)
Parameters
| object | The name of an EntitySet, a relationship with fields, a form, a structured application document, or a set. Can be a role name for an EntitySet or relationship with fields. |
Comments
In a set specification, UNRELATED selects all records in object that do not satisfy the relationship condition expressed in the set specification.
UNRELATED can be used only once in a set specification.
This function is related to the theoretical partial outer join operation.
Example
> find all Employees (unrelated) WorkIn Departments
> list all
LastName FirstName DeptNum DeptName DeptNum
Johnston Leslie D07
Nelson John
Kelly Pat
The preceding command finds all employee records that contain no DeptNum, or contain a DeptNum for which there is no corresponding department record. Missing values are undefined ($Null).
find all Employees WorkIn Departments (unrelated) keep Departments
The preceding command creates a list of all departments that have no employee records associated with them.
find all Managers (unrelated) Manage Employees
Finds all employees that do not manage anyone. (For a contrasting example, see COMPLETE.)
See Also
– (Dynamic Rename)
COMPLETE
USING
Syntax
$ProgramFileName
Return Value
Character string (varalpha). Cannot be reset by an application program.
Comments
Contains the file system name of the disk file that contains the currently executing program. AREAS.ZIM or DIRS.ZIM entries that apply to the file are expanded, as are the special prefix characters (i.e. #,),^,~,”).
See Also
$filepath
Sets the minimum acceptable date.
Syntax
SET VALIDDATE min_date
Parameters
| min_date | The minimum acceptable date (e.g. 19000101) |
Comments
Example
By default, the minimum acceptable date in Zim is 0. The following assignments are accepted without warnings
>let nDate = 0.
>let pDate = 19991231.
>let qDate = 20010101.
However, when the minimum acceptable date is set to 20000101, the first two assignments generate warnings:
>let nDate = 0.
*** Warning *** DATE value is invalid but the operation was performed.
>let pDate = 19991231.
*** Warning *** DATE value is invalid but the operation was performed.
The following assignment executes without warnings:
>let qDate = 20010101.
Captures a bitmap image of the screen and writes it to a file.
Syntax
$screensave(filename)
Parameters
| filename | a character string, or an expression that evaluates to a character string |
Return Value
Returns “1” ($True) if no errors were detected when the image was written to filename. Otherwise, returns “0” ($False).
Comments
Filename must be the name of a disk file, including the path location. A document name cannot be used.
The size of the terminal screen in character columns.
Syntax
$screenwidth
Value
A number. Cannot be reset by an application program.
Description
$ScreenWidth gives the width of the terminal screen in character columns.
In graphic environments, the number of columns depends on the font and point size used in the application window (BACKSCREEN).
See Also
$ScreenHeight
System Variables
ThisWindow
Controls the availability of the “break” key to the application user.
Syntax
SET BREAKABLE ON|OFF
Comments
The BREAKABLE option is set ON by default.
When BREAKABLE is ON, the application user may press the “break” key to terminate any command being executed. SET BREAKABLE OFF instructs the software to ignore the signal generated by the terminal “break” key.
The SET BREAKABLE command is not affected by the SET RESET and SET RESTORE commands.
See Also
$BreakFlag
The size of the terminal screen in character rows.
Syntax
$screenheight
Return Value
A number. Cannot be reset by an application program.
Description
$ScreenHeight gives the height of the terminal screen in character rows.
In graphic environments, the number of rows depends on the font and point size used in the application window (BACKSCREEN).
See Also
$ScreenWidth
System Variables
ThisWindow
Portuguese 
English