Problem with decimal separator

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

  • Re: Stupid Number Parsing And How To Fix It
    ... have a separator, probably an underscore: ... Furthermore, if the decimal separator is involved, the underscores ... Forgive my failing memory, but is a comma ever valid inside a set of? ...
    (comp.lang.java.advocacy)
  • Re: Rough draft: Proposed format specifier for a thousands separator
    ... non-locale aware way to format a number ... It is not the goal to replace locale or to accommodate every ... COMMA is used when a PERIOD is the decimal separator. ...
    (comp.lang.python)
  • Re: Problem with decimal separator
    ... >> The locale of my computer uses comma as decimal separator. ... >> It seems to me that since ADOQuery uses Sql request and Sql request uses ...
    (borland.public.delphi.database.ado)
  • Re: Problem with decimal separator
    ... > The locale of my computer uses comma as decimal separator. ... > It seems to me that since ADOQuery uses Sql request and Sql request uses ...
    (borland.public.delphi.database.ado)
  • Decimal Setting within IIS
    ... the Comma as Decimal Separator. ... I use Windows 2003 Server french version and I have some troubles with a ... All the numbers come with comma ...
    (microsoft.public.inetserver.iis)