This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I've just spotted a little problem with the SQL generated by the designer when using MySQL and GUID indentities (not sure if it applies in other cases). 1) Create an entity with a many to one relationship to another entity 2) Update Database 3) Database now has a reference column defined correctly as a char(32) 4) Change the "is nullable" property in the designer 5) Update Database 6) Database column now has type varchar(10) which causes the foreign key relationship to fail. Example of the SQL produced at this last step:
-- Change column NewsItem from nullable to non-nullable ALTER TABLE `TextItem` MODIFY `NewsItem` VARCHAR(10) NOT NULL DEFAULT '';
This is with the 20090810 nightly build. Thanks, Chris |
|
|
|
|
I've committed a fix for this and it will be in nightly builds dated 14 Aug 2009 and above. Thanks for letting us know about it. |
|
|
|
|
Thanks Ivan, the fix works in my full model :-) Chris |
|
|
|
