Generate DDL

[katrin]

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.

[«Midnight»]

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

[katrin]

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

[«Midnight»]

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