An IN comparison is logically true if expression is equal to at least one of the values in the specified list. A NOT IN comparison is logically true if expression is not equal to any of the values in the specified list. In either case, the comparison ends as soon as a logically true instance is found.
The syntax of a call to a procedure is procname (expression) Parameters procname The name assigned to the procedure in its PROCEDURE or LOCALPROCEDURE command. expression Any value expression. Comments The list of expressions must be enclosed in parentheses; even when no expressions are required, the parentheses must still appear. At the prompt level, you can issue a call to the main procedure of any procedure program. Within a procedure program, you can issue a call to any…
Read more
Names for objects defined in the Object Dictionary must conform to the following conventions: The name can be from 1 to 18 characters in length. The name can contain only letters (a-z, A-Z), digits (0-9), dollar signs ($), and underscores (_). The name must begin with a letter or a dollar sign. Most names must be unique among objects of the same type in the same application…
Read more
There are two types of permissions – object permissions (EntitySets, relationships, and directories) and field-level permissions. Field level permissions take precedence over object permissions. The permissions are set as follows: The following chart summarizes the permissions needed in order to successfully execute a given form of data manipulation on an object where permissions are currently in place. Definitions are as follows: Owner refers to the user who…
Read more
Except in certain limited instances (e.g., security passwords, values held in objects of data type CHAR and VARCHAR), the software is case insensitive. Insensitivity to case means that the software makes no distinction between uppercase and lowercase letters in any part of a statement. For example, the following statements are identical, provided LastName is not a CHAR or…
Read more
Any value expression used in an application – including the names of objects that represent values – must conform to one of the available data types. Data Types and Objects Objects that represent values (constants, variables, fields and form fields) have an explicit data type attribute defined in the Object Dictionary. Value expressions that are not defined objects take implicit data types. The data type of…
Read more
Output masks are employed to format the output of fields, form fields, and data values in output operations. The MASK format option in Zim Reports specifies an output mask pattern for a report item. The $mask function specifies an output masking pattern to be applied to fields, form fields, and data values and returns a character string with the result of the masking operation. The Field Mask attribute defines the expected output format of a field’s data value…
Read more
Any meaningful combination of the following options can be applied to any value displayed in a report: CENTER The Report Generator is to center the associated item on the current line. Centering is relative to the PAGEWIDTH specified in the REPORT FROM command. The default value for PAGEWIDTH is 80. COLUMN n The Report Generator is to start display of the associated item at character column n. COLUMN…
Read more
Triggers an exception handler in the absence of an exception condition. Syntax SET EXCEPTION condition Parameters condition Can be BREAK Mimics a terminal or process “break” condition (i.e., the user pressing the “break” key). DEADLOCK Mimics a deadlock in a multi-user system. Does not abort the current transaction. ERROR Mimics an error condition. WARNING Mimics a warning condition. Comments A SET EXCEPTION command mimics…
Read more
A macro is a dynamically declared name that represents a character string. When a macro call is encountered in an application program the macro call is replaced by the current character string value of the macro. Macros are sometimes called replacement parameters or substitution variables. The following topics discuss how to work with macros in applications: Availability of macros How macros acquire values Macro Substitution Macros and…
Read more
English 
Portuguese