Sets the interval between set-processing progress messages. Syntax SET MEMBERINTERVAL num Parameters num Num can be: an integer constant (e.g., 15, 200) a variable, form field, menu item, or parameter that evaluates to an integer. Comments The MEMBERINTERVAL option is set to 1 by default. The MEMBERINTERVAL option determines how many records are to be…
Read more
Halts the execution of an application program if an error occurs. Syntax SET STOP ERRORS ON|OFF Comments The STOP ERRORS option is OFF by default. When STOP ERRORS is switched ON, execution is halted (by the HALT utility) when an error occurs. To resume execution after the HALT, press Enter at the HALT prompt (>>).…
Read more
SET EXECUTEMODE Controls the mode of software execution. Syntax SET EXECUTEMODE SQLMODE | ZIMMODE | SERVERMODE Comments The EXECUTEMODE option is set to SQLMODE by default. The SQLMODE option executes SQL database code. The SERVERMODE option executes integrated Zim server code. The ZIMMODE option executes standard Zim code. In ZIMMODE, EntType, RelType, and so on…
Read more
Returns the absolute value of a number. Syntax $absolute(number) where number a number, or an expression that evaluates to a number Return Value Number, positive, with the same number of decimal places as number. Comments Use $absolute to ensure that a number is positive (for functions such as $sqrt, for example). $absolute returns the absolute…
Read more
Converts alphabetic characters to lower case. Syntax $tolower(source) Parameters source any value, or an expression that yields any value Return Value Character string. Comments Returns a character string in which all letters are lower case. If source is not of a character data type, it is converted to a character data type before the function…
Read more
Controls consistency checking of result sets. Syntax SET CHECKSETS ON|OFF Comments The CHECKSETS option is set ON by default. When CHECKSETS is ON, the software checks certain aspects of the component structure of result sets for consistency. This consistency checking is performed when a command creates a result set (using the -> (Result set) subcommand),…
Read more
SET SQLCOMPILE Controls the compilation of generated SQL statements within the SQL database. Syntax SET SQLCOMPILE ON|OFF Comments The SQLCOMPILE option is OFF by default. The software stores SQL statements generated in the compiled code and executes them dynamically at run time. When SQLCOMPILE is switched ON, the software attempts to compile all generated SQL…
Read more
EVALUATE Evaluates expressions while the main command processes a set of records. Syntax EVALUATE «expression» Parameters expression Any valid expression, but usually an assignment using LET and an aggregate function. If expression is complex, it must be enclosed in parentheses. Example change all Employees where LastName = Smith let Salary = 1.1 * Salary evaluate…
Read more
Determines the month name associated with a specified date value. Syntax $monthname(date) Parameters date a data, or an expression that evaluates to a date, in the form YYYYMMDD Return Value Character string. Comments This function extracts month information from standard date values. Date is often the system variable $Date. The values returned by the $monthname…
Read more
Tests if a character string is a valid date. Syntax $isdate(string) Parameters string a character string or an expression that evaluates to a character string Return Value 1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False). Comments This function tests if a particular character string is…
Read more
English 
Portuguese