Re: Problem with decimal separator

Yes. Accualy I do it just this way. QuotedStr is mandatory.
"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:42ba6d1c$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> have you tried this ?ADOQuery.Filter := 'Cost ' + QuotedStr('0,0358');
> --
> Best regards :)
>
> Guillem Vicens
> Dep. informática Green Service SA
> www.clubgreenoasis.com
> --
> In order to send me a mail, remove the -nospam
>
> "kolja2003" <NOSPAMkolja2003@xxxxxxx> escribió en el mensaje
> news:42ba5e1b@xxxxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> > The locale of my computer uses comma as decimal separator. So MS Access
> > database uses comma as decimal separator too which is OK.
> >
> > BUT when in my program I uses ADOQuery.Filter:='Cost='0,0358''; I get
> > empty
> > dataset. Notice comma as decimal sepatator!
> > Same time when I use period in it like this:
> > ADOQuery.Filter:='Cost='0.0358''; it works fine. The recordset isn't
empty
> > and funny but it has comma(!) as decimal separator not period. Remember
I
> > don't change locale!
> >
> > It seems to me that since ADOQuery uses Sql request and Sql request uses
> > period as decimal separator then the first expression with comma didn't
> > work
> > despite it is legitimate from point of view of locale.
> >
> > SO I have question can I somehow command ADOQuery to legitimate comma
> > instead of period in Sql request?
> >
> >
>
>


.

Relevant Pages