| Subject | Is FB supports the dynamic SQL in stored procedure? | 
|---|---|
| Author | Dara Durum | 
| Post date | 2011-03-07T12:01:07Z | 
Hi! 
I want to ask that is fb supports dynamic usage of SQL, or variable as
SQL (or part of SQL) statement in stored procedures?
:tablename = call CreateTempTable;
insert into :tablename ....
drop table :tablename
or (FireBird like cursor handling):
sql = "select * from " || :tablename || " where..."
for select :sql ....
...
Thanks for your help:
dd
            I want to ask that is fb supports dynamic usage of SQL, or variable as
SQL (or part of SQL) statement in stored procedures?
:tablename = call CreateTempTable;
insert into :tablename ....
drop table :tablename
or (FireBird like cursor handling):
sql = "select * from " || :tablename || " where..."
for select :sql ....
...
Thanks for your help:
dd