Transfers control to another procedure. Syntax TRANSFORM procedurename [(]expression[)] Parameters procedurename The name of the procedure to which execution control is to be transferred. expression Parameters or macros for procedurename (formatted as when calling the procedure). Comments TRANSFORM transfers execution control to the specified procedure, but does not return control to the calling procedure once…
Leia mais
Specifies the page heading for a report. Syntax PAGE HEADING [BREAK HEADING indicator] reportitem [:format:] Parameters indicator Indicator can be OFF Suppresses all break headings at the top of each new report page. LEVEL n Causes the break heading for break level n and below to be displayed at the top of each report page.…
Leia mais
Changes or assigns a password to the current Zim user ID. Syntax PASSWORD newpassword [oldpassword] Parameters newpassword The new password, up to 18 characters. Any characters are valid (i.e., letters, digits, punctuation). $Null is also valid; its effect is to remove a password. Can also be an expression. If necessary, the expression is converted to…
Leia mais
WHERE States a condition. Syntax WHERE expression Parameters expression A logic expression using conditional and Boolean operators. Comments WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered. Of all the available (related) records…
Leia mais
Deletes records from EntitySets or relationships with fields. Syntax DELETE [ALL] FROM SQLsetspec [EVALUATE clause] [-> clause] Parameters ALL Optional. Whether or not you include the ALL argument, all records in SQLsetspec are deleted. SQLsetspec An SQL set specification. If omitted, records are deleted from the current set (if it exists). Comments DELETE FROM is…
Leia mais
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…
Leia mais
KEEP Keeps (retains) some components in a result set while discarding others. Syntax KEEP «component» Parameters component The name of a component found among the objects declared in a set specification. Any number of components can be specified, provided they appear among the declared objects. Comments In certain instances, you want to select records from…
Leia mais
Assigns a name to the set of records processed by the main command. Syntax -> setname The set of records processed by the main command is given the name setname. where setname The name to be assigned to the result set. Comments You can explicitly create a result set by adding the characters -> and…
Leia mais
UNION Combines the members of two or more result sets into a single set. Syntax set1 UNION set2 Parameters set1 The name of a result set that resulted from the execution of a set-producing command. Set1 and set2 must have the same component structure. set2 The name of a result set that resulted from the…
Leia mais
COMPLETE Used as a part of a set specification to select both matching and non-matching members of an EntitySet, a relationship with fields, a form, a menu, a result set, or a structured application document. Syntax object (COMPLETE) Parameters object The name of an EntitySet, a relationship with fields, a structured application document, a form,…
Leia mais
Portuguese 
English