Moves the current member pointer one or more records “up” in a result set. Syntax PREVIOUS [num] [setname] Parameters num The number of members “further up” into setname that the current member pointer is to be moved. Num can be:an integer constant (15, 200);a variable, form field, or parameter that evaluates to an integer;the…
Read more
Positions the text cursor in the current window. Note: This command has been deprecated in Zim 8.50.It is still accepted for backwards compatibility, but it is ignored. Syntax CURSOR expression1 expression2 Parameters expression1 A number or an expression that evaluates to a number. If the expression is complex, it must be enclosed in parentheses.Indicates…
Read more
Converts a value into its numeric equivalent. Syntax $tonumber(expression,decimals) Parameters expression Any value, or an expression that yields any value. decimals A number specifying the number of decimal places required in the converted value. Decimals can be negative. Return Value Number equivalent of expression. Comments Use $tonumber to obtain the numeric equivalent of expression. If…
Read more
Identifies the current user to Zim for security purposes. Syntax LOGIN username [password] Parameters username A character string, or an expression that evaluates to a character string.The character string is checked against the list of valid user names (as defined in the Users EntitySet). User names are case-sensitive.Complex expressions must be enclosed in parentheses. password…
Read more
Returns the minimum value of a set of values. Syntax $min(expression) Parameters expression any expression Return Value The value of the selected instance of expression. Comments Use $min to find the smallest value among members of a set. Instances of expression that are $Null are ignored. Expression is often a WHERE expression that includes only…
Read more
Shifts the focus to the open form in the current window and puts the application user in control of the interface. Syntax FORM INPUT [PURGE] Parameters PURGE Causes unprocessed input, received before the FORM INPUT command was executed, to be ignored. Eliminates the possible affects of inadvertent keystrokes or mouse actions before the application user…
Read more
Specifies the report footing. Syntax REPORT FOOTING [TEMPLATE name] reportitem [:format:] Parameters TEMPLATE name For graphical reports, the name of an optional template to define the layout of the report. reportitem Any valid expression. Complex expressions must be enclosed in parentheses. When you specify more than one expression, each must be separated from the next…
Read more
Compiles an application program. Syntax COMPILE progdocname Parameters progdocname The name of the application document that contains the application program to be compiled. Comments The COMPILE command reads the program compiles it, and stores the compiled version in a separate disk file. The source program is then marked as being compiled. Thereafter, the compiled version…
Read more
Returns the maximum value of a set of values. Syntax $max(expression) Parameters expression any expression Return Value The value of the selected instance of expression. Comments Use $max to find the largest value among members of a set. Instances of expression that are $Null are ignored. Expression is often a WHERE expression that includes only…
Read more
Returns the average value of a set of values, excluding $Null values. Syntax $average(expression) Parameters expression any expression Return Value Number, with the number of decimal places implied by expression. Comments The function calculates the average of a set of values, excluding $Null values. Expression is often a WHERE expression that includes only selected values…
Read more
English 
Portuguese