Subject Re: [firebird-support] Using "twice-dynamic" SQL in a stored procedure
Author Milan Babuskov
Alexandre Benson Smith wrote:
> mizbrodin wrote:
>> I have a set of tables having the same structure like "CREATE TABLE
>> tables_list1 (tblname VARCHAR(128))" (let's call them "list tables").
>> These list tables contain the names of some other tables (let's call
>> them "referenced tables"). I need to implement a stored procedure,
>> which would accept the name of a list table via an input parameter and
>
> You could use EXECUTE STATEMENT

Here's an example:

http://www.firebirdfaq.org/faq322

--
Milan Babuskov
http://www.guacosoft.com