Subject | Filtering TIBOQuery |
---|---|
Author | Marcin Bury |
Post date | 2000-12-28T17:20:34Z |
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
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