Re: Problem with decimal separator

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