FAQ's - APPX Software, Inc. : APPX Utility : APPX Development Environment : Tips & Techniques :
How to make a negative sign appear in front of the number (instead of behind) | |
First, go to the Data Dictionary for the numeric source field, and enter a
default display mask with the minus sign whenever you want it. Note: You
can also put currency symbols, commas, and anything else you might need.
Then, in the process where you want to move it to an alpha, you just say:
CNV TEXT <alpha field> = <numeric field> The CNV TEXT field will honor the default display mask, and put the minus sign where you want. If you put currency symbols, commas, etc, they will also be formatted into the alpha field. The same thing applies if you use a date field as the source, APPX will format the date according to the date mask, so you don't get '20010517--------', you get '5/17/2001'.
APPX will use your default mask in other places as well, which may or may
not be a good thing (inputs and outputs that use the numeric field will be
affected). If you are concerned about that, you can create a new numeric
field with the default mask you want, SET the original field into the new
one, and then use CNV TEXT.
| |
[Append to This Answer] | |
2004-Jan-07 2:16pm |
Previous: | How can I read the USER list? |
Next: | How to display high ASCII characters. |
|