Set Specification Identifies particular records in an Zim database. Syntax object [WHERE clause] [SORTED BY clause] [KEEP clause] Parameters object The name of an EntitySet, relationship, form, application document, or result set. Role names can be used for EntitySets or relationships. Any number of objects can be specified, provided that they are meaningful in context.…
Read more
-> (Dynamic Rename) Renames a component of the set specification in the main command. A set specification can consist of one or more components. When you create a result set, the structure of that set reflects the component names or role names found in the original set specification. To use a result set in a…
Read more
Identifies particular records in an SQL database. Syntax Object [WHERE clause] [GROUP BY expr1] [HAVING expr2] [ORDER BY expr3 [ASC|DESC]] [KEEP component] Parameters object The name of an EntitySet, relationship, form, structured application document, or result set. Role names can be used for EntitySets and relationships. expr1 A value expression. Specifies how the selected records…
Read more
Indicates if an explicit transaction is in progress. Syntax $intransaction Return Value “1” ($True), or “0” ($False). Can be reset by an application program. Description $InTransaction acts as a flag, indicating if the software is currently processing an explicit transaction. $InTransaction is set to “1” ($True) if a TRANSACTION (or BEGIN WORK) command has started…
Read more
ThisMenu A data structure that provides information about the state of the system and of the current menu at the time of the last event in that menu. The ThisMenu data structure provides information about the state of the system and of the current menu at the time of the last event in the current…
Read more
A data structure that provides information about the state of the current form at the time of the last event in the current window. The ThisForm data structure provides information about the state of the current form at the time of the last event in the current window. The ThisForm structure contains a number of…
Read more
ThisWindow A data structure that provides information about the state of the system and of the current window at the time of the last event in that window. The ThisWindow data structure provides information about the state of the system and of the current window at the time of the last event in that window.…
Read more
Compares one value to a specified range of values. Syntax expression [NOT] BETWEEN expr1 AND expr2 Parameters expression An expression that evaluates to either a number or a character string. expr1 An expression that evaluates to either a number or a character string. expr2 An expression that evaluates to either a number or a character…
Read more
Alters the order of evaluation of expressions, or groups expressions, or both. Syntax #1 Alters the order of evaluation in expressions. (expression) Within a larger expression, a single expression placed in parentheses changes the order of execution (which normally depends on the precedence of operators). Parameters expression an arithmetic or logic expression Syntax #2 Groups…
Read more
Performs a Boolean OR of two logic expressions. Syntax expression1 OR expression2 Parameters expression1 A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. expression2 A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. Return Value…
Read more
English 
Portuguese