Subject | Re: Param Value lost within query |
---|---|
Author | tomjanczkadao |
Post date | 2012-02-24T15:10:35Z |
>(...)
> 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