Devart Forums

I exported a schema today and found a very strange bug.
What should have been generated:
CONSTRAINT FOREIGN KEY (SomeId)
REFERENCES fkTable(Id) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT FOREIGN KEY (SomeId2)
REFERENCES fk2Table(Id) ON DELETE NO ACTION ON UPDATE NO ACTION,
What was generated:
CONSTRAINT FOREIGN KEY (SomeId)
REFERENCES fkTable(Id) ON DELETE NO ON UPDATE NO ,
CONSTRAINT FOREIGN KEY (SomeId2)
REFERENCES fk2Table(Id) ON DELETE NO ON UPDATE NO ,
Was wondering if you guys knew about this, if it could be fixed, or if i'm just doing something wierd. Thanks!

Actually our application doesn't write DELETE or UPDATE rules for foreign keys if they are set as NO ACTION, because this is the default behaviour.

Can you provide us with additional information:
1. What version of MySQL server do you use?
2. What version of dbFroge Studio for MySQL do you use?
3. Could you send us the DDL text of these tables?
4. Which wizard do you use to generate DDL text (Schema Export wizard or Generate DDL wizard) ?

Latest DevART dbForgeFusion i JUST installed it.
Here is the top with info about it
-- Script was generated by Devart dbForge Fusion for MySQL, Visual Studio 2008 Add-In, Version 3.50.327.0
-- Script date 7/29/2009 8:48:14 AM
-- Server version: 5.0.67-community-nt-log
-- Client version: 4.1
and i tried with both schema export and generate DDL.
I think i may have a problem though, for example i don't have any devArt projects in the file->new menu...

Okay i think i have a bigger issue, i can't seem to create a project. Following the working with projects how to i can't even seem to create a project. The templates just don't exist. Any ideas?

Unfortunetly, we cannot reproduce the problem with FOREIGN KEY DDL text generation. We've tested on many MySQL servers..

I think i may have a problem though, for example i don't have any devArt projects in the file->new menu...

What edition of dbForge Fusion for MySQL are you using?
Projects are available only in professional edition. For more information, please read the article at http://www.devart.com/dbforge/mysql/stu ... tions.html