| Subject | Re: [firebird-support] Execute statement cant handle parameters which are NULL |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-12-24T20:39:01Z |
At 04:24 PM 24/12/2009, ainpoissee wrote:
Please observe the directions in the General Notes section of the v.2.5 release notes and post this question in firebird-devel. In order to avoid the "20 Questions" scenario, provide all the relevant code for this problem, *including* the statement string.
^ heLen ^
>Hi,[snip]
>
>I'm using EXECUTE STATEMENT in trigger with two parameters like
>
>EXECUTE STATEMENT (:Statement) (NEW_Alates := NEW.Alates, NEW_Kuni := NEW.Kuni) INTO :Count;
>
>The problem is, that when either of the parameters is NULL then exception is raised:
Please observe the directions in the General Notes section of the v.2.5 release notes and post this question in firebird-devel. In order to avoid the "20 Questions" scenario, provide all the relevant code for this problem, *including* the statement string.
^ heLen ^