Directives for Numeric Pictures (Magic xpa 4.x)
The tables below provide a list of positional and functional directives for Numeric pictures.
|
|
|
|
#{n}
|
A placeholder for a digit.
|
|
.
|
Indicates the location of the decimal separator, as defined in the Environment dialog box.
|
|
|
|
|
|
A
|
Auto Skip
|
Instructs Magic xpa to move automatically to the next variable when the user has entered characters, filling up all of the available space in the current field.
Default: No
Platform specific: This directive is not supported for mobile devices.
Exceptions: Auto Skip is not supported for Browser Client tasks.
This directive is not available in Web Client tasks.
|
|
N
|
Negative
|
Instructs Magic xpa that this variable may contain negative values. If Yes is specified, Magic xpa automatically enlarges the display size of the picture, as portrayed by the template, to enable a sign to be displayed.
Default: No
|
|
C
|
Commas
|
Instructs Magic xpa to insert commas as thousands separators in the variable. If you specify Yes, Magic xpa automatically enlarges the display size of the picture, as portrayed by the template, to include positions for commas. Commas may be replaced by any other character as specified in the Thousands Separator variable of the Environment dialog box.
Default: No
This directive is not available in Web Client tasks.
|
|
L
|
Left justify
|
Instructs Magic xpa to left-justify the variable value when displayed.
Default: No (right-justified)
This directive is not available in Web Client tasks.
|
|
Pc
|
Pad fill
|
Instructs Magic xpa to fill the part of the displayed variable that does not contain digits with the character specified in “Character:” If you do not specify a character, the variable is padded with blanks.
Default: No
This directive is not available in Web Client tasks.
|
|
Zc
|
Zero fill
|
Instructs Magic xpa to fill the entire displayed variable with the Character value if its value is zero. If you do not specify any character, the variable is padded with blanks.
Default: No
This directive with 'blank' zero fill characters is available in Web Client tasks. Other characters are not supported. Since version: 4.7
|
|
-c{,S};
|
Negative sign
|
Lets you enter a prefix and/or suffix that will be displayed when the field is negative.
If you want to display a string instead of the conventional minus sign (-) to indicate a negative value, use the - directive followed immediately by the new sign prefix, a comma, the new sign suffix, and then a semicolon (;). To display a string at the end of a negative value, type the string you want in the Suffix parameter.
For example:
-
The picture N4.3+,CR;-,DB; specifies that positive numbers should be suffixed with the string CR and negative numbers with the string DB.
-
The picture N10.2C+$;-$-; specifies that both negative numbers and positive numbers will be prefixed with a $ sign.
This directive is used often to display currency symbols.
|
|
+c{,S};
|
Positive sign
|
Lets you enter a prefix and/or suffix that will be displayed when the field is positive.
If you want to display a string instead of the conventional plus sign (+) to indicate a positive value, use the + directive followed immediately by the new sign prefix, a comma, the new sign suffix, and then a semicolon (;). To display a string at the end of a positive value, type the string you want in the Suffix parameter.
For example:
-
The picture N4.3+,CR;-,DB; specifies that positive numbers should be suffixed with the string CR and negative numbers with the string DB.
-
The picture N10.2C+$;-$-; specifies that both negative numbers and positive numbers will be prefixed with a $ sign.
This directive is used often to display currency symbols.
|
For variables with the Numeric attribute, the # directives, the count values, and the optional decimal position character define the number of digits in the whole part and in the decimal part. This in turn defines the default storage field model and length of the variable.
|
|
n - represents the count value
{ } - represents an optional part
c - represents a mask character. To use a directive character, for example X, where c appears, preface it with a backslash, as in \X.
|
The bottom area of the dialog box shows the exact template of the variable as it will be displayed, that is, which mask characters are displayed and how many positions the variable will occupy on screen or report forms.
Examples of Numeric Pictures
