Subject Re: [firebird-support] Dinamic SQL in Firebird !
Author Martijn Tonies

> 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
Upscene Productions