Subject Re: construct in PROC
Author grat007
Thanks,
this work :)
Milan
--- In firebird-support@yahoogroups.com, Gabriel Juncu <gjuncu@c...>
wrote:
> 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