Subject | Re: [firebird-support] Using "twice-dynamic" SQL in a stored procedure |
---|---|
Author | Milan Babuskov |
Post date | 2008-01-16T10:50:22Z |
Alexandre Benson Smith wrote:
http://www.firebirdfaq.org/faq322
--
Milan Babuskov
http://www.guacosoft.com
> mizbrodin wrote:Here's an example:
>> 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
http://www.firebirdfaq.org/faq322
--
Milan Babuskov
http://www.guacosoft.com