Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: katrin on May 14, 2008, 05:44:47 pm

Title: Generate DDL
Post by: katrin on May 14, 2008, 05:44:47 pm

Is it possible to run "Generate DDL" function for a db table with Automation Interface? I would like to generate sql for a table automatically and I can't find any function in the sparx documentation for doing this.

Title: Re: Generate DDL
Post by: «Midnight» on May 14, 2008, 10:04:58 pm

From memory...

Select the table involved, and while it is selected (you should see the visible indicator on the diagram) go through the usual DDL generation process. This should now generate the DDL for the selected table rather than the entire package.

David

Title: Re: Generate DDL
Post by: katrin on May 15, 2008, 05:36:23 pm

sorry, probably I wasn't precise. What I meant was to use an API function for doing this. I know how to generate ddl for a table 'manually' - by selecting a table and then a function from the menu. However, I would like to write an Addin to sparx that will do it automatically. Is there any function for doing this? There is "GenerateClass" but I can't find any "generateDDL", "GenerateSQL", etc.
I think that my problem is similar to the one stated here: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1210790829

Title: Re: Generate DDL
Post by: «Midnight» on May 15, 2008, 08:04:33 pm

I've answered another post today on this subject: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1210790829.

Please make the feature request as well. We've got to get this to 'bubble up' to the top of the stack.

David