Kbase P32904: Numeric format is wrong in 4GL sessions after reinstalling Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2010 |
|
Status: Verified
SYMPTOM(s):
Numeric format is wrong in 4GL sessions.
Comma and dots are swapped when viewing numeric fields.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CHANGE:
Reinstalled Progress.
CAUSE:
During the installation process, the correct numeric format was not selected.
FIX:
Edit the file named startup.pf in your Progress installation directory.
Change or add the -numsep and -numdec options therein to match the desired display format for numeric fields.
For example, if you want the number "one thousand twelve comma nine nine" to be displayed as "1,012.99" then the following parameters are needed:
-numdec 46
-numsep 44
This is the default way that Progress displays dates.
If you want the same number to be displayed as "1.012,99" then the following parameters are needed:
-numdec 44
-numsep 46
This corresponds to using the -E start-up option to display numbers in European format.
Note if data was imported that had the correct format while the wrong format was being used, this may result in your data being stored incorrect.