The Procedures Palette

The Palette
Palettes are repositories of basic resources which become, in this case, the building blocks and manipulators of the Procedure being created.  Procedures are used in six different applications:

All Procedure Palettes have at least three basic views (Print templates are applicable to the Report Procedure only):

Main resources

Database Source
Database Fields
Operators and dividers
Draggable objects (Trigger conditions)
Draggable objects (functionality explained)



Print templates (applicable to the Report Procedure only)


Procedures Palette - Main Resources
Main resources has three groups of resources (the image shown is that of the Common Template Procedure Palette, hence the Fields shown under Resources - Local are the fields as they occur in the Common Template; it also has Display only fields) :


Unique to User Functions, Report and Process Procedures

Common to all Procedures

Initially the contents of the new Variable is EMPTY. It can be set by explicitly assigning a value to the Variable in the Calculation object, through the Function object, or Array Out object. Unlike the Parameter, whose data type is explicitly set in the Parameters object, the Variable's data type is inferred from the context of the Procedure in which it is used. Selection of the data type in this case is done according to the following rules:

count = 0 count  is INTEGER
weight = 1.5 weight  is FLOAT
name = 'Unknown' name  is TEXT
paid = NO paid  is LOGICAL

If there are several assignments of value to the same Variable that set it to different data types, then the result may be either a syntactical error, or one of the data types taking over. For example, assigning a FLOAT value to a Variable of INTEGER type will make (promote it to) a FLOAT type, while the assignment of TEXT type, in similar circumstances, is treated as an error.

+ Plus
- Minus
X Multiply
/ Divide
= Assign value of
> Greater than
>= Greater or equal
< Less than
<= Less or equal
== Equal
!= Not equal
AND Logical AND
OR Logical OR
[ Start of field
] End of field
( Start of group
) End of group
; End of statement


AddToDate function increments or decrements the date by the given number; the number is treated as days, weeks, months or years according to the setting of the Units parameter. The Function takes the following input parameters:

<Date> original date,
<Increment> number of date units to be added (if positive) to or subtracted (if negative) from the original date,
<Units> date units.

Once a Function object is brought into the Workspace and the function name (e.g. AddToDate) is selected (click or drag-and-drop), the object expands to receive the parameters:

Procedures Palette - Account lists
Account lists can be utilized when defining the Search Criteria for database related activities e.g. retrieval; or in Function objects. The view has two columns:

Procedures Palette - Account groups
Account groups can be utilized when defining the Search Criteria for database related activities e.g. retrieval; or in Function objects. The view has two columns:

Procedures Palette - Print templates
The Print templates view will be displayed when a Print object is loaded into the Procedure's Workspace or when specifically selecting Print templates Palette tab.

When the Print Template Name has been loaded into the Print object in the Workspace, the Inspector will display the Print template variables, if any, and show placeholders for the flowchart variables that carry data to be printed by the template.


Go to:
Table of Contents