thanks thomas

but i learn that it is a bad practice to use execute statement to do something that is normally forbidden :(

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > Hello,
> > Is there a way in FireBird to pass a table name as parameter to stores procedure ?
>
> And I guess using this table name than in the stored procedure to do
> some work?
>
> You can pass the table name as parameter, but then you need to execute
> the statement inside the procedure with EXECUTE STATEMENT.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>