Subject | Re: Using functions when filtering an IBOQuery |
---|---|
Author | patrick_marten |
Post date | 2012-12-06T14:36:44Z |
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.
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
>
> ,
>
> "
>