It was actually a bug that it worked previously but since some of you have
grown accustomed to it I am going to see about making support these SQL
constructs:

BETWEEN <expr> AND <expr>
IN( )
CONTAINING <expr>
STARTING [WITH]

Please, keep in mind that these are SQL syntax, not Filter syntax.

For now, use the equivalent syntaxes for them with <= AND >= as well as OR
and so on.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Vercom (JM Huys)" <info@...>
To: <IBObjects@egroups.com>
Sent: Thursday, December 07, 2000 3:04 PM
Subject: Re: [IBO] filter


> aankopen.filter := 'jaar = '+J +' and periode between '+van+ ' and '+tot;
>
> this raises the same exception token unknown between
> ----- Original Message -----
> From: "Vercom (JM Huys)" <info@...>
> To: <IBObjects@egroups.com>
> Sent: Thursday, December 07, 2000 11:00 PM
> Subject: [IBO] filter
>
>
> > Hi,
> >
> > since I use ibobjects 3.6bc the following filter raises an exeption :
> > error code 335544569
> > ... token unknow ... and
> >
> > data.vkdoc.filter := 'f_striptime(datum) between '+#39+
> formatdatetime('mm/dd/yyyy', start.date) +#39+ ' and '+#39+
> formatdatetime('mm/dd/yyyy', einde.date) + #39;
> >
> > This filter worked with previous versions.