Book a Demo

Author Topic: Entering data types  (Read 3580 times)

jeshaw2

  • EA User
  • **
  • Posts: 701
  • Karma: +0/-0
  • I'm a Singleton, what pattern are you?
    • View Profile
Entering data types
« on: January 05, 2005, 10:11:59 pm »
I'm on day 1 of the evaluation period.  I'm trying to create a database diagram.  I've got the table onto the drawing and defined my primary key, but the drop-down box for the column data type is empty.  I've specified MS Access as the db type, but still nothing in the dropdown.

How do I get the data type specified.?  I can't specify any FKs without them.
Thanks
Jim
Verbal Use Cases aren't worth the paper they are written upon.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Entering data types
« Reply #1 on: January 06, 2005, 01:15:13 pm »
Set the DBMS from the Database dropdown. You can also set a default DBMS from Configuration | Database Datatypes... select the DBMS from the Product Name drop down and check "Set as Default".

Create the column and set it's datatype.

Now add this column to the primary key.

Alternatively, when creating the column, check "Primary Key" and the pk operation will be generated.

jeshaw2

  • EA User
  • **
  • Posts: 701
  • Karma: +0/-0
  • I'm a Singleton, what pattern are you?
    • View Profile
Re: Entering data types
« Reply #2 on: January 10, 2005, 02:21:37 pm »
Well, it only worked for a little bit, then the data types went away again.  I've set a default database data type of SQL Server 2000 in the configuration menu to no avail.  You mentioned that I could also set the database type in the "Database Dropdown".  The only such dropdown I could find was in the config area.  Where is this other one?

Thanks
Jim
Verbal Use Cases aren't worth the paper they are written upon.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Entering data types
« Reply #3 on: January 10, 2005, 04:36:10 pm »
Tools | Options | Generation | Code Editors | Default Database.