Subject Re: [firebird-support] Building query strings in stored procedures?
Author Ann W. Harrison
willogibbo wrote:
>
> Using something like PHP it is possible to build up an sql query
> string to perform on the database, depending on what filters, how many
> filters, and the values within the filters, the user chooses ...
>
> What I would like to be able to do is replicate this within a stored
> procedure ...

Check the EXECUTE STATEMENT statement. You can build up a SQL statement
in a procedure then execute it.


Regards,


Ann