Moves the current member pointer one or more members “down” in a result set. Syntax DOWN [num] [setname] Parameters num The number of members farther “down” into setname that the current member pointer is to be moved. Num can be an integer constant (15, 200); a variable, form field, or parameter that evaluates to an…
Read more
Extracts a segment from the front of a character string. Syntax $left(source,length) Parameters source a character string or an expression that evaluates to a character string length a number or an expression that evaluates to a number Return Value Character string, consisting of a string containing length characters from source, starting in the first position.…
Read more
Applies a mask pattern to the specified data item. For a more detailed explanation of mask patterns and their relation to data types, see Masking. Syntax $mask(item,pattern) Parameters item A value of any type or an expression that yields a value of any type; or An field of any data type. pattern The mask pattern…
Read more
Converts an expression to the character data type and sets the length of the result. Syntax $tocharacter(expression,length) Parameters expression Any value, or an expression that yields any value. length A number that specifies the number of characters in the resulting character string. Length can be a constant, a variable, a form field, or a parameter.…
Read more
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
English 
Portuguese