Re: Problems with DBMONEY or with comma and period

> 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. Thomas ______________________________________________________________ ____ ___ | \\ \\ | | | Thomas Behr \\ \\ | | | Thomas.Behr@uvw.uni-bayreuth.de \\ \\| | UNIVERSITY Of | voice: (++49) 921 - 55 52 75 \\_______| BAYREUTH | fax: (++49) 921 - 55 84 52 75