Category: ZIM 4GL Language Reference

The Original Internet Language

XOR

Performs a Boolean XOR of two logic expressions. Syntax expression1 XOR expression2 Parameters expression1 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. expression2 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. Return Value Logical as follows: Truth…
Read more

$position

Locates the first occurrence of a pattern in a character string. Syntax $position(source,pattern) Parameters source a character string, or an expression that evaluates to a character string pattern a character string, or an expression that evaluates to a character string Return Value Number, being the position of the first character in source that matches the…
Read more

$insert

Inserts a character string into another character string. Syntax $insert(source,position,string) Parameters source a character string, or expression that evaluates to a character string position a number or an expression that evaluates to a number string a character string, or expression that evaluates to a character string Return Value Character string consisting of source, with string…
Read more

$toalpha

Converts an expression to the alpha data type and sets the length of the result. Syntax $toalpha(expression,length) Parameters expression Any value, or an expression that yields any value. length A number. Can be a constant, a variable, a parameter, a menu item, or a form field. Return Value Character string (alpha), length bytes long. Comments…
Read more

$delete

Deletes a portion of a character string. Syntax $delete(source,position,length) Parameters source a character string or an expression that evaluates to a character string position a number or an expression that evaluates to a number length a number or an expression that evaluates to a number Return Value Character string, consisting of source, less those characters…
Read more

LOCATE

Locates a particular member of a result set and makes it the current member. Syntax LOCATE [num] [set] [WHERE clause] Parameters num The number of records to be located. Num can be an integer constant (e.g., 15, 200); a variable, form field, menu item, or formal parameter that evaluates to an integer; the word ALL.…
Read more

UPDATE

Changes data in EntitySets, relationships, forms, or sets. Syntax UPDATE [ALL] [SQLsetspec] SET «field = value » [WHERE clause [EVALUATE clause] [-> clause] Parameters ALL Optional. Regardless of whether ALL is entered, all records in the set specification that meet the specified condition (if any) are updated. SQLsetspec An SQL set specification. Can contain application…
Read more

USING

USING In a set specification, qualifies a relationship. Syntax relationship («USING obj1 AS obj2») Parameters relationship The name of the relationship being qualified. obj1 The name of an object used elsewhere in the set specification in which relationship appears. Must be the name or role name of an EntitySet, relationship, form, or application document. Must…
Read more

SET (Field Attributes)

Modify certain attributes of fields. Syntax SET <fieldname> REQUIRED ON|OFF SET <fieldname> FIELDLISTWIDTH <number> SET <fieldname> HEADING <charstring> SET <fieldname> MASKFIELD <charstring> SET <fieldname> REMNAME <charstring> Parameters fieldname The name of a field. ON or OFF Specifies if the field can have the value $null. This is equivalent to changing the REQD field to “yes”…
Read more

$Exist$

Checks whether a given Zim object exists in a Zim directory. Syntax $exist$(Zim directory name, object name, object type) Parameters Zim directory name A character string or an expression that evaluates to a character string, naming the ZIM directory to which the object would belong object name A character string or an expression that evaluates…
Read more

en_CAEnglish