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