Dear informixers:
Does anybody observed this problem?
(Specially non-english language people)
If you set the environment variables DBMONEY or DBFORMAT to
replace the decimal point by comma and viceversa, the behaviour of the
engines (SE or OnLine) is altered and cannot correctly find your query on
money/decimal/floating point numbers.
For example, if you CONSTRUCT a query on a money field named PRICE,
and you request
Price [>10 ]
or Price [>10.0 ]
or Price [>10,0 ]
the result of the CONSTRUCT will be: price>"10,0" (with quotes), but the
engine will SELECT smaller, greater or = values with an unknown criteria.
In the other hand, if you dbexport the database, and then dbimport
the same data, with the environment variables DBMONEY and/or DBFORMAT set,
you will get a database with the money/decimal/floating point numbers
multiplied by ten or a hundred.
The problem is located on the engines (both), because you get the
same results from a 4gl program or dbaccess.
SE version 5.00
OL same
RDS version 4.12
SCO unix 4.3.4
If you have a solution or a workaround, please let me know.
Thank you all.
Mario Canto
tconsex%ceride.conicet.edu.ar@fpsp.fapesp.br (preferred)
tconsex@arcride.edu.ar (UUCP)
tconsex@ceride.bitnet (BITNET)
Santa Fe
Argentina