Category: ZIM 4GL Language Reference

The Original Internet Language

SET OUTPUT FORMAT

Establishes the format for data output. Syntax SET OUTPUT FORMAT [ NORMAL  |  COMMADELIMITED  |  XML  |  XMLSIMPLE  |  JSON  |  JSONSIMPLE ] Comments The value of OUTPUT FORMAT is NORMAL by default. That is, the LIST and OUTPUT commands create output whose format exactly follows the Object Dictionary definitions of the individual fields being…
Read more

SET DECIMALS

Enables or disables the requirement of typing the decimal point. Syntax SET DECIMALPOINT ON|OFF Comments The DECIMALPOINT option is set ON by default. DECIMALPOINT only has an effect on entry fields during FORM INPUT: When DECIMALPOINT is ON: typed digits fill the input mask from the right-most digit leftwards there is no need to type…
Read more

SET SELECTIVITY

Specifies index selectivity for indexed fields. Syntax SET SELECTIVITY fieldname value1 value2 value3 or SET < fieldname> SELECTIVITY value1 value2 value3 Parameters fieldname The name of an indexed field. value1 A number in the range 0.000 to 1.000. The number specifies the index selectivity for equality (=) searches. A number above or below the acceptable…
Read more

SET COMMANDTIMING

Displays how much time each command takes to execute. Syntax SET COMMANDTIMING ON|OFF Comments The COMMANDTIMING option is set OFF by default. The SET COMMANDTIMING command controls the output of command timing messages. In UNIX, the format of command timing messages is source, line, IU|RU, user ticks, elapsed user ticks, IS|RS, system ticks, elapsed system…
Read more

SET SAVE

Saves the current global application settings in their current state for later use. Syntax SET SAVE Comments The SET SAVE command records the current state of all global settings, and pushes the group of settings onto a stack of previously saved settings (if any). The SET RESTORE command pops the top group of settings off…
Read more

SET RESTORE

Restores the top group of settings in the stack of saved global settings created by SET SAVE. Syntax SET RESTORE Comments The SET SAVE command records the current state of all global settings, and pushes the group of settings onto a stack of previously saved settings (if any). The SET RESTORE command pops the top…
Read more

SET FOR UPDATE

Instructs SQL commands to be generated with the FOR UPDATE OF option. Syntax SET FOR UPDATE ON|OFF Comments When connected to any SQL servers, the SQL syntax generated to perform operations on the remote server can be controlled to add the FOR UPDATE OF option on the primary key fields to SELECT commands. The option…
Read more

SET (EntitySet/Data Relationship Attribute)

SET (EntitySet/Data Relationship Attribute) Modifies the value of an attribute of a database object. Syntax SET tablename tabletype [ “ZIMSERV” | “JDBCSAM” | alias name ] SET tablename [ remname |  remowner ] value SET fieldname [ remname ] value tablename is the name of an EntitySet or data relationship fieldname is the name of…
Read more

{ } (Case)

Selects one in a series of values. Syntax { expression1 , expression2 } Parameters expression1 any value expression expression2 any value expression Return Value The value of the first of the expressions that is not $Null. Comments The expressions within the braces are evaluated from left to right. The case expression takes the value of…
Read more

PARSE

Tests a single Zim command, or an application program, for syntactic and semantic accuracy. Syntax PARSE commandstring | docname Parameters commandstring Any character string, enclosed in quotation marks, that represents a Zim command to be parsed. docname The name of an application document that contains an application program to be parsed. Comments The PARSE command…
Read more

en_CAEnglish