Subject Re: Using functions when filtering an IBOQuery
Author patrick_marten
Please disregard the initial message.
I've mixed up a few things somehow...

The filter should be

(TRUNC(TABLENAME.FIELDNAME, 0) = 16)

of course and works fine, sorry.


--- In IBObjects@yahoogroups.com, "patrick_marten" <patrick_marten@...> wrote:
>
> Hello,
>
> is it possible to use functions like "ROUND" or "TRUNC" for filter criteria of an IBOQuery?
>
> I'm trying to apply a filter like
>
> (TABLENAME.FIELDNAME = TRUNC(16, 0))
>
> but am getting an error
>
> "token unknown
>
> ,
>
> "
>