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