Re: Problems with DBMONEY or with comma and period

Thomas Behr writes: * > Thomas Behr <Thomas.Behr@uvw.uni-bayreuth.de> wrote: * ... * > >If we set DBMONEY='.' everything is ok. * > >But if we set DBMONEY=',' we can insert and display decimals (no * > >moneys!) like '12,50', but we cannot search for this value. * The same effect with MONEY values. * > * Paul Roberts hatte geschrieben: * > Hmmm... interesting. Do you mean that in order to pull up records * > with a value of twelve and a half DMs, you have to enter "12.50" * > in the field when you in query mode, even though when the records * > are displayed they display as "12,50"? * To clear up: * DBMONEY=',' * To add a value of twelve and a half, i enter '12,50'. * I can query for values like '>0' or '>12' and i see '12,50'. * But i cannot query exact for twelve and a half; i tried * '1250','12,50','12.50','12,5' and so on. * I think, it is not a problem of my hardware or of my terminal * settings, because friends tried it on an other platform. On our platform (SCO Unix 3.2.4) it works fine setting the DBMONEY=, and then searching on '12,50' to get the values. Maybe it is a platform problem. Robert Minter Data Systems Support \\\\\\_/// Senior Software Engineer A Client Technologies Company ( _ _ ) E-Mail: rob@dssmktg.com Tel: 714.771.0454 (| ^ |) #include <disclaimer.h> Fax: 714.771.3028 \\`-'/ De Colores - Emmaus OC-13 SURF'S UP \\_/