At 11:01 AM 02-01-01 +0100, you wrote:

>Hi,
>
>After instaling version 3.6.Ca some of my ib_querys doesn't accept filter
>string.
>Database, transactions, Keylinks ... here is not important.
>Example:
> Filter = 'DateFrom >= "01.01.2001"' -> ok
> Filter = 'DateFrom >= "01.01.2001" and DateFrom < "02.01.2001"' -> error:
>token unknow '='
>
>Thanks for your replay.

1. Don't include Filter=

2. Use single quotes on the date literals.

3. Don't put quotes around the filter string

The first example evaluates to a Boolean so it is "correct" from a logical
point of view.
The second "does not compute". :))

should be
(1) DateFrom >= '01.01.2001'
(2) DateFrom >= '01.01.2001' and DateFrom < '02.01.2000'

H.


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________