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
Extracts a segment of a character string. Syntax $substring(source,position,length) Parameters source a character string, or an expression that evaluates to a character string position a number, or an expression that evaluates to a number length a number, or an expression that evaluates to a number Return Value Character string, containing a string extracted from source,…
Read more
Makes an open window available for viewing and interaction by the application user. Syntax WINDOW ACTIVATE [window] [EXPOSE|HIDE] Parameters window Window can be name The name of an open window. The software looks up name in the currently accessed directories in the usual way. A compiled command using name contains the unambiguous name of the…
Read more
Presents online help information. Syntax HELP [topic] Parameters For files that invoke the winhelp executable topic A character string or a number, or an expression that evaluates to a character string or a number. Identifies a particular help topic in the help file. If topic is a character string, the HELP command accesses the help…
Read more
Starts and defines a procedure. Syntax PROCEDURE procname ([IN|OUT|INOUT] parm) [LOCAL (var)] Parameters procname A valid object name. Procname must be the name of the existing application document that contains this procedure and must not conflict with a system keyword. IN, OUT, or INOUT Designates the direction in which the associated parm passes a value:…
Read more
Defines and marks the start of a local procedure within an application program. Syntax LOCALPROCEDURE procname> ([IN|OUT|INOUT] parm)[LOCAL(var)] Parameters procname A valid object name. The name of the local procedure cannot conflict with a software keyword. When a local procedure name conflicts with a pre-defined object name, the local procedure name takes precedence, provided…
Read more
Breaks the body of column-oriented reports into summary groups. Syntax COLUMN BREAK level [HEADING reportitem [:format:]] [FOOTING reportitem [:format:]] Parameters level The break level number (an integer greater than or equal to zero). In the hierarchy of breaks, the higher the level number, the more minor the break. (For example, a level 1 break also…
Read more
Specifies index selectivity for indexed fields. Syntax SET SELECTIVITY fieldname value1 value2 value3 or SET < fieldname> SELECTIVITY value1 value2 value3 Parameters fieldname The name of an indexed field. value1 A number in the range 0.000 to 1.000. The number specifies the index selectivity for equality (=) searches. A number above or below the acceptable…
Read more
Replaces a portion of a character string with another character string. Syntax $replace(source,position,length,string) Parameters source a character string, or an expression that evaluates to a character string position a number, or an expression that evaluates to a number length a number, or an expression that evaluates to a number string a character string, or an…
Read more
English 
Portuguese