Subject Re: Param Value lost within query
Author tomjanczkadao
>
> Are you sure that both params are of the same type, Tomek? E.g. if
> MY_DATE is defined as DATE whereas extractyear takes a TimeStamp
> parameter, then IBO believes them to be different parameters
(...)

Hi
Great thanks :) That was exactly the point. My overcome was second parameter, but CAST definitely solves the problem.
It's dirty behaviour of IBO however. IBExpert prepared this statement as supposed.

Regards, Tomek