Re: DBMONEY error ?

June Tong escribi': > Evelio Mart'nez wrote: > > > - INFORMIX-SQL Version 5.10.UC1 > > - INFORMIX-4GL Version 4.00.UC2 > > Pcode Version 7 > > You are on a WAAAYYY old version of 4GL, and I'm sure your SQL version is > incorrect, as there is no SQL 5.10. Perhaps you meant SE? Sorry, you are right. I meant SE 5.10. > > > > This behaviour creates an assymmetry between input and output. You have > > to input . and you will see , as decimal separator. > > > > Is this correct ? > > No, I don't think this could possibly be correct. Sorry but this is correct.Any numerical value (decimal, float, money, etc.) must have a using with "---,---,---.---" or viceversa "---.---.---,---". If I have DBMONEY=, it changes the decimal separator to comma (,) when I display it (believe or not). When the program is at input it shows point (.) as decimal separator and does not understand (,) as as fraction separator. > > > Do I have to upgrade ? > > Yes. 4.00.UC2 is VERY OLD (also VERY BUGGY). There have been lots of > issues with getting decimals to display properly when using a > non-US-standard format; there's bound to be lots in 4.00. I know it is an old buggy version. I am afraid if I want to fix this behaviour I will have to upgrade. > > > June > -- > june_t@hotmail.com > Grounded in Palo Alto, living on Oreo's Thanks -- Evelio Mart'nez Office: +34 96 374-47-02 +34 96 374-47-03 programacionaf@sinix.net