Subject | Re: [firebird-support] construct in PROC |
---|---|
Author | Gabriel Juncu |
Post date | 2003-07-28T10:03:56Z |
Hi grat007,
Monday, July 28, 2003, 11:26:20 AM, you wrote:
g> Hi,
g> I have a question,it is possible to make this contruction in procedure?
g> SELECT CTAB FROM CC WHERE ID=1 INTO :cname
g> DELETE FROM CTAB WHERE .....
If you are using Firebird 1.5, the following is possible:
select CTAB from CC where ID=1 into :CNAME;
execute statement 'delete from ' || CNAME || ' where ...';
Regards,
Gabriel Juncu
Monday, July 28, 2003, 11:26:20 AM, you wrote:
g> Hi,
g> I have a question,it is possible to make this contruction in procedure?
g> SELECT CTAB FROM CC WHERE ID=1 INTO :cname
g> DELETE FROM CTAB WHERE .....
If you are using Firebird 1.5, the following is possible:
select CTAB from CC where ID=1 into :CNAME;
execute statement 'delete from ' || CNAME || ' where ...';
Regards,
Gabriel Juncu