Re: Problem with decimal separator


> 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.

Filter property have nothing to do with SQL that stands behind TADOQuery. In
a few words situation is as follows (assuming you are using client side
cursors, which is mandatory for Filter):

1. ADO retrieves results of SQL query and holds them locally in memory

2. Once you are assigning Filter it applies filter condition, it applies in
to in memory recordset and hide records that don't match to filter



As you have found out, syntax for Filter on client side have a lot of
limitations and ignoring of regional settings is among them.



Regards,

Vitali


.