Subject | TIb_Script to create stored procedure |
---|---|
Author | Mike Terry |
Post date | 2002-04-17T23:07:54Z |
Hello all,
I want to be able to create my database from within my application and want to use sql ddl commands to do it. I created a data module and placed a series of TIb_Script components on it. There is one for domains and one for each table.
So far I'm able to use CreateDatabase to create the empty database and then execute the scripts to define the domains and tables. Where I'm having trouble is in defining stored procedures.
Can anyone give me an example of a "create procedure" call that will work from within a TIb_Script component?
Thanks
Mike
I want to be able to create my database from within my application and want to use sql ddl commands to do it. I created a data module and placed a series of TIb_Script components on it. There is one for domains and one for each table.
So far I'm able to use CreateDatabase to create the empty database and then execute the scripts to define the domains and tables. Where I'm having trouble is in defining stored procedures.
Can anyone give me an example of a "create procedure" call that will work from within a TIb_Script component?
Thanks
Mike