Subject RE: [IBO] Filter sintax problem
Author Dominik Murk
Helen,

> 1. Don't include Filter=
Sorry, I should wrote: IB_Query property filter is : datafrom...

I write as you said but the same error still stand.

Dominik Murk
MILENIJ group



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