| Subject | Re: [firebird-support] Copy Table in store procedure |
|---|---|
| Author | Milan Babuskov |
| Post date | 2012-01-10T11:00:52Z |
Ahmet Nuri D wrote:
execute it with EXECUTE STATEMENT.
If structure is "fixed", it's easier to dump the DML using some tool and
then EXECUTE STATEMENT.
Why do you want to do it in a procedure?
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> Hi, I want to copy table in store procedure, whith all trigers, generators. How can i do that?Use system tables to extract metadata info and build DML and then
execute it with EXECUTE STATEMENT.
If structure is "fixed", it's easier to dump the DML using some tool and
then EXECUTE STATEMENT.
Why do you want to do it in a procedure?
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================