Converts an expression to the date data type. Syntax $todate(expression) Parameters expression Any expression. To be meaningful, it should yield a number that has meaning in the format YYYYMMDD. Return Value Date. Example $date – $todate(19980923) In the preceding arithmetic expression, 19980923 is treated as the date 23 September 1998 instead of the number 19,980,923.…
Read more
Trims leading blanks from a character string. Syntax $ltrim(string) Parameters string a character string or an expression that evaluates to a character string Return Value Character string. Comments Use $ltrim to remove leading spaces from a character string. For output purposes, the implicit length of the result returned by $ltrim is the same as the…
Read more
The current user’s operating system group ID. Syntax $groupid Return Value A character string, or $Null. Cannot be reset by an application program. Description The current user’s operating system group ID (if the operating system supports group IDs); otherwise, $Null. You can use the $UserID and $GroupID system variables to build levels of security into…
Read more
Controls required field checking for EntitySets and relationships with fields. Syntax SET CHECKNULLS ON|OFF Comments The CHECKNULLS option is set ON by default. When CHECKNULLS is ON, an error results if a Required field is assigned the $Null property during an ADD, CHANGE, INSERT, or UPDATE command. Normally, you should always leave CHECKNULLS set ON.…
Read more
Trims leading and trailing blanks from a character string in a field. Syntax $trim(string) Parameters string a character string, or any expression that evaluates to a character string Return Value Character string. Comments Use $trim to remove leading and trailing spaces from a character string in a field. For output purposes, the implicit length of…
Read more
Makes the last member of a result set the current member. Syntax BOTTOM [setname] Parameters setname The name of a result set. If a setname is not specified, the current set is used. Example To find all Employees with Jones as a last name, to identify the result set as KeepName, and to set the…
Read more
$ZUserID The application user’s Zim user identifier. Syntax $zuserid Return Value The user identifier of the user specified in the last successful LOGIN command. Cannot be reset by an application program. Description Upon successful execution of a LOGIN command, $ZUserID is set to the specified user’s ID. Although you can change the value of this…
Read more
Prints or displays a graphical reports previously created. Syntax PRINT REPORT name TO destination Parameters name The name of a Zim document that contains the graphical report. destination The destination can be the SCREEN or to the PRINT. Comments The Zim document specified by name must contain a graphical report previously generated by a REPORT…
Read more
The error code generated by the last command that returned an error code. Syntax $lasterrcode Return Value A number (1 to 9999). Can be reset by an application program. Description The reason for the failure of the most recently executed command that returned an error code other than 0 (success) At the beginning of each…
Read more
Calculates a date value by adding days to (or subtracting days from) from a specified date value. Syntax $adddays(date,number) where date a date, or an expression that evaluates to a DATE data type number a number, or an expression that evaluates to a number Return Value Number, representing a DATE value. Comments Use $adddays to…
Read more
English 
Portuguese