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…
Leia mais
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.…
Leia mais
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…
Leia mais
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.…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
Portuguese 
English