Thanks!

Is there a limit in the number of lines in a stored procedure?

Regards!

Yoli

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
> > How can I implement a stored procedure that executes dinamic sql
> > queries?
> >
> > I'm working with Firebird 1.0.3. I need to launch a query

depending

> > on the input parameters, all of these parameters are optional.
>
> With Firebird 1.0.x, you cannot construct dynamic SQL
> statements inside a Stored Procedure. This is a Firebird 1.5
> feature.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com