Hello,

> Nobody knows a way to insert a dynamic SQL in a procedure?

I do, I do :-)

> We want to change the number of restrictions in a query, in function
> of an input parameter.
>
> The solutions that we done is change the query contraints with delphi
> or duplicate the code in firebird's procedure, but this is a ugly
> solution and its more difficult to maintain the code...
>
> Has firebird resources to solve this problem by himself?

Firebird 1.5 has - take a look at EXECUTE STATEMENT in
the Release Notes.

For versions before 1.5, you're out of luck.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com