Peculiar Display of Output with MD2 formatting (Arev32)
At 16 AUG 2010 02:14:29PM Mat Kelly wrote:
I am bringing data over from an Arev31 system to Arev32 by simply using DOS XCOPY and rebuilding the indexes. One particular field on a screen has the output format of "MD2,$". In Arev31, the stored value is displayed correctly as "$13,000.00". In Arev32, the same data in the same window (in Arev32 instead of Arev31) is displayed as "$$1,3,0.00". Selecting this field in Arev32 and re-entering "1300000" and saving corrects the problem but with each new port of the data, this value displays incorrectly.
What is preventing the same data from being displayed differently in the two systems? What can I do to assure that the ported data is displayed correctly in Arev32 as it does in Arev31?
At 16 AUG 2010 02:29PM Dave Harmacek wrote:
Looks like a TimeDate Format or a Localization setting.
These settings for OI are in the Database Manager.
At 16 AUG 2010 02:57PM Charles Steadham wrote:
Dave,
As far as I can tell, there are many other entities (each of which would have a value for this field) that are formatted correctly. Wouldn't these global settings have an effect on others? Would you mind expanding on where I might find these settings?
Thanks.
At 16 AUG 2010 03:28PM Dave Harmacek wrote:
Since you are "porting" the data are you sure it is stored
as the ICONVd value?
So, I would bring up an offending record in a Editor
and examine the data stored on that position.
btw, if you entered 1300000 into a prompt it should show $1,300,000.00
At 16 AUG 2010 07:29PM Warren Auyong wrote:
It appears to me that the data is not be ICONVed into integer format and instead of being OCONVed a display format mask is being applied. If you edit records how is the data in the column in question stored? Is it integer format, no dollar signs, commas or periods? If it contains any of these characters then either the validation pattern and/or the output format are not properly defined for the prompt in the Window. Try changing these to something else, save the Window, change to back to (MD2) and MD2,$. If you're using a user defined conversion or subroutine then your problem may lie there.
If the data is not in integer format should write a program/procedure to ICONV the data, e.g. ICONV(x,'MD2').