Category: Subcommands

USING In a set specification, qualifies a relationship. Syntax relationship («USING obj1 AS obj2») Parameters relationship The name of the relationship being qualified. obj1 The name of an object used elsewhere in the set specification in which relationship appears. Must be the name or role name of an EntitySet, relationship, form, or application document. Must…
Read more

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

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

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…
Read more

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…
Read more

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…
Read more

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,…
Read more

SORTED BY Sorts the members of the set produced by the main command. Syntax SORTED BY «expression [ASCENDING|DESCENDING]» Parameters expression An expression that identifies a field to be used as a sort key. Complex expressions must be enclosed in parentheses. ASCENDING or DESCENDING Specifies how the sort on the associated key is to be performed.…
Read more