Generate DDL

[Mohammad Salman]

Hi:

This here is a great product indeed.  But I need help with some thing.  I am trying to do some data modeling.  I have created a table.  Now I want create the DDL for the table/model.  The help says that I should use the context menu (right button click) for the table and choose  'Generate DDL'.  My problem is that I don't see 'Generate DDL' in the context menu.

Can some one please help.  Thanks.

-Mohammad

[Marc Walter]

Go to the PACKAGE containing the table, right click, code engineering - Generate DLL...  should work.
Marc

[Mohammad Salman]

Marc:

Thanks so much for your quick reply.  Unfortunately I still have the same problem.  

Here is what I have done.  This is waht I have in a new project.  'Logical View' -> 'Data Model' -> 'test_package_1' -> logical view model -> a logical diagram that has my table.  

I hope I have not confused you.  Any way, clicking on the package or the table itself does not give me either 'Generate DLL' or 'Code Engineering -> Generate DLL'.

What could I be doing wrong or missing. Any ideas?

Marc, I appreciate your help.  Thanks again,

-Mohammad

[jaimeglz]

Hi, Mohammad. Welcome to this forum.

I suggest you first make sure you have set up what database product you are using, as explained in the following thread:

http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.cgi?board=general&action=display&num=1029799422

Now, double-click on your table icon (either in the project tree or in the diagram), go to Table Detail and make sure you have entered your attributes (colums), with their most important information. Alfter you have checked this, OK or cancel you Table Detail dialog.

Double click on your table icon again, and go to Table Detail. Click the "Generate DDL" button in the dialog. Select your path, and generating options. Generate your code, then View.

I hope this will be of help to you.

Jaime Gonzalez

[Mohammad Salman]

Hi Jamie:

Thanks for your help.  I had indeed set the database to Oracle.  I had the same problem of the empty datatype list.  But even then I can't see the Generate Code or Generate DDL menu anywhere.  I don't even see a grayed out version of it.

In the Table Detail page I only see Table space (??), Columns/Attributes and Operations.  No generate DDL.

I must be overlooking something basic and elementary.  But I can't figure out what it is.  I am using the desktop version.  

Thanks for your help again.

-Mohammad

[jaimeglz]

Hi Mohammad,

I've tried to reproduce the situation you describe: namely, that you are not seeing a "Generate DDL" button in the "Table detail" dialogue. I have used EA 3.10 Professional Edition (build 497) and the latest EA "lite" (the EA version we use to distribute our diagrams to our customers who don't have EA licenses). So far, I have not been able to understand what is happening to your table.

I haven't played with all the configuration options, and I hope someone from Sparx Systems can recognize what is causing this (you are using an earlier version of EA lite, perhaps?).

Meanwhile, I would suggest you download the fully functioning EA, and try again.

By the way, the "Table space" field in the Table Details dialogue is for the database your table belongs to. I know very little about Oracle, but in Sybase and SQL Server this is the first part of a fully qualified table name:

mydatabase.mytable

Good luck, and I'll be following this thread.

Jaime Gonzalez

[Mohammad Salman]

Hi jaime,

Thanks for your reply and your effort to solve this problem.  

I have a licensed version of the software, so I guess that should make it fully functional.  

And here are the details: Program version 3.1.0 version 489.  I see that it is an older build than yours.  I will try to get a new one.  

BTW, I have also sent an email to the Sparx system.  I 'll share with you what the say.

Thanks again.

-Mohammad

[Mohammad Salman]

Hi Jaime,

You know, you were right.  I just downloaded the latest version and I can now generate the DDL and see all the menu items Marc and you were talking about.  The DDL has some problems but atleast it is there.

Many thanks, Jaime.

-Mohammad