Performs a Boolean XOR of two logic expressions. Syntax expression1 XOR expression2 Parameters expression1 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. expression2 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. Return Value Logical as follows: Truth…
Read more
Locates the first occurrence of a pattern in a character string. Syntax $position(source,pattern) Parameters source a character string, or an expression that evaluates to a character string pattern a character string, or an expression that evaluates to a character string Return Value Number, being the position of the first character in source that matches the…
Read more
Inserts a character string into another character string. Syntax $insert(source,position,string) Parameters source a character string, or expression that evaluates to a character string position a number or an expression that evaluates to a number string a character string, or expression that evaluates to a character string Return Value Character string consisting of source, with string…
Read more
Converts an expression to the alpha data type and sets the length of the result. Syntax $toalpha(expression,length) Parameters expression Any value, or an expression that yields any value. length A number. Can be a constant, a variable, a parameter, a menu item, or a form field. Return Value Character string (alpha), length bytes long. Comments…
Read more
Deletes a portion of a character string. Syntax $delete(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, consisting of source, less those characters…
Read more
Locates a particular member of a result set and makes it the current member. Syntax LOCATE [num] [set] [WHERE clause] Parameters num The number of records to be located. Num can be an integer constant (e.g., 15, 200); a variable, form field, menu item, or formal parameter that evaluates to an integer; the word ALL.…
Read more
Changes data in EntitySets, relationships, forms, or sets. Syntax UPDATE [ALL] [SQLsetspec] SET «field = value » [WHERE clause [EVALUATE clause] [-> clause] Parameters ALL Optional. Regardless of whether ALL is entered, all records in the set specification that meet the specified condition (if any) are updated. SQLsetspec An SQL set specification. Can contain application…
Read more
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
Modify certain attributes of fields. Syntax SET <fieldname> REQUIRED ON|OFF SET <fieldname> FIELDLISTWIDTH <number> SET <fieldname> HEADING <charstring> SET <fieldname> MASKFIELD <charstring> SET <fieldname> REMNAME <charstring> Parameters fieldname The name of a field. ON or OFF Specifies if the field can have the value $null. This is equivalent to changing the REQD field to “yes”…
Read more
Checks whether a given Zim object exists in a Zim directory. Syntax $exist$(Zim directory name, object name, object type) Parameters Zim directory name A character string or an expression that evaluates to a character string, naming the ZIM directory to which the object would belong object name A character string or an expression that evaluates…
Read more
English 
Portuguese