In the very latest release if you want pure SQL only then you can tell IBO
not to parse the filter text by using the prefix ::SQL::

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

----- Original Message -----
From: "Marcin Bury" <mbury@...>
To: <ibobjects@egroups.com>
Sent: Thursday, December 28, 2000 10:20 AM
Subject: [IBO] Filtering TIBOQuery


> Hi
>
> I'd like to put the following statement into TIBOQuery.Filter property
>
> fn_month(data_w)=12
>
> where fn_month is an udf returning month from timestamp field.
> When I turn on filtering I get error and this statement seems to be parsed
> to
> AND (fn_month( data_w) = AND 12 (accordingly to ServerSQL string)
>
> Any solution?
> In version 3.6A it was ok, problem started to appear since v. 3.6B and
still
> exists in 3.6Ca
>
> TIA
> Marcin
>
>
>
>
>
>