--- In firebird-support@yahoogroups.com, "martinthrelly"
<martinthrelly@...> wrote:

>
> hi adam thanks for your reply.
>
> i wrote a previous reporting app and the syntax i referred to does
> work. i used a set of preset filters for each report and
> conditionally ran them in the WHERE clause depending upon whether
> the input parameter value was null or not. so it does work. where
> the user wanted to define multiple filters such as "WHERE code in
> (1, 3, 4, 6, etc) i appended this onto the end of the SP call.
>
> i dont think i can use execute statement with firebird 1.5.

You can. See the release notes for details. You wont be able to use
parameters with it, so you will need to do the whole:

... (d.code = || departmentcode || '))

It is certainly not ideal.

Adam