Subject Re: [firebird-support] construct in PROC
Author Gabriel Juncu
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