MySQL, Datetime, DDL-Issue

[Henrik Raböse]

EA: 12.0.1215

In the database builder: Column "adddate", Type "Datetime". I can't change or remove the "Length" (0).



The DDL-Generator make this.

Code: [Select]

CREATE TABLE `customer`
(
`id` BIGINT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(150) NOT NULL,
`adddate` DATETIME(0) NOT NULL,
`addby` BIGINT NOT NULL,
`changedate` DATETIME(0) NOT NULL,
`changeby` BIGINT NOT NULL,
CONSTRAINT `PK_customer` PRIMARY KEY (`id`)
)


The generated code has an SQL-Error: Datatype "DATETIME" has not a length. "`adddate` DATETIME(0) NOT NULL,"



regards
Henrik

[qwerty]

For which database?

q.

[Henrik Raböse]

Sorry.
But it is in the subject: MySql.

[qwerty]

lol

I just tried this with MySQL and my EA does not create the number:

Code: [Select]

`date` DATETIME NULL
used release 1224. So maybe you should update?

q.

[Henrik Raböse]

Ok, thank you for this hint.
I'll try this again with update and report my result.

regards
Henrik

ps.
There is an update to the version 1224?

pps.
I've updated to version 1230 and the DDL-code looks like good .

[qwerty]

Formerly I had been on the latest release whenever possible, but I'm no longer that adventurous ;-)
But probably it's better to update to the latest version once you ran into trouble.

q.