Messages

1

General Board / Re: MySQL DDL generation

« on: December 16, 2004, 12:42:25 pm »

Mike -

Problem resolved.  Once you got me in the right direction, it's a simple error; I'm using a reserved word, "Desc".

Thanks again for your help.

Pete

2

General Board / Re: MySQL DDL generation

« on: December 16, 2004, 11:31:15 am »

Mike -

You're right on.  I was looking at command structure, not statement structure.  I will investigate further myself also.  I'll let you know if I find anything and look for your response.

Thanks

3

General Board / Re: MySQL DDL generation

« on: December 16, 2004, 09:40:47 am »

Molto Mike -

Thanks for your response.  I'm using MySQL 4.1.7 and EA Build 744.

Here is a sample .sql file generated by EA.

--  -------------------------------------------
--  Generated by Enterprise Architect Ver. 4.01
--  Created On : Monday, 13 December, 2004
--  DBMS       : MySql
--  -------------------------------------------

CREATE TABLE Areas11
(
RecID INTEGER NOT NULL COMMENT 'Record ID generated by system.',
AreaID CHAR(5) NOT NULL,
Desc VARCHAR(50) NOT NULL COMMENT 'Descriptio of Area.',
Nickname CHAR(15) NOT NULL,
SortField CHAR(15) NOT NULL,
GpsData TEXT,
AreaManagerID CHAR(6),
AreaOfficeLocClRecID INTEGER,
Comments78RecID INTEGER COMMENT 'Comments for all Tables are stored in Comments78.  Comments can be up to 500 characters long and are stored as 2 250 variable character fields (Comment, Comment2).',
PRIMARY KEY (AreaID),
UNIQUE (RecID),
KEY (Comments78RecID)
) Type=InnoDB COMMENT='Master Table of defined Areas to be used by Client.'
;

It is very clear in the MySQL documentation that comments can only be structured in one of three ways.  The above is not one of them.  Appreciate any help.

4

General Board / MySQL DDL generation

« on: December 15, 2004, 10:39:38 pm »

I'm generating MySQL DDL files from tables I've defined in EA.  The problem is that the .sql files use a 'COMMENT' keyword for the column and table comments, which is not valid in MySQL.  Comments must be setoff by "--", "/* */", or '#'.  If I change the option in the "Generate DDL" window, it only changes the .sql file header, which is correct with "--" already.  Nothing seems to change the column and table comments.

I'm I missing something here?

Also, I seem to be doing something wrong as far as configuring the "View" option.  I went to "local paths" and setup and "Applied" a path to "EditPadPro" directory, the editor I use, but I still can't get the "View" button to function.

Thanks,

Pete

5

General Board / Re: EA vs Borland Together

« on: December 13, 2004, 11:35:30 pm »

One advantage of Together - it supports JBuilder.  We are waiting for EA to support Java as it does .net.