Ok, I am finally able to report that I have this working along with all of
the other valid (simple) SQL syntax items. They are:

IS [NOT] NULL
[NOT] BETWEEN ... AND ...
[NOT] IN ( ... )
[NOT] LIKE ... ESCAPE ...
[NOT] CONTAINING ...
[NOT] STARTING [WITH] ...

This is all in addition to the former syntax and it is all integrated into
the filtering options as well. PartialMatch only applies when the operator
is '=' and the asterisk and case insensitivity applies to all of them and it
will substitute in the NOCASE columns indicated in the ColumnAttributes
automatically.

This will be in 3.6 Ca

I will release the source for it in just a few minutes. I also have the
calculated fields bug fix in this sub-release too.

Regards,
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.
> >
> > ???
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
>
>
>
>
>