Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Extra validations

 Post Reply Post Reply
Author
Hugo Logmans View Drop Down
New Member
New Member
Avatar

Joined: 18 Feb 2011
Posts: 3
Post Options Post Options   Quote Hugo Logmans Quote  Post ReplyReply Direct Link To This Post Topic: Extra validations
    Posted: 18 Feb 2011 at 9:34am
Hi,

I get the following validation errors in SQL Server 2008, that you might add to the validator functions in Data Modeler.

Introducing FOREIGN KEY constraint 'Clients_Declarations' on table 'Declarations' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

Cannot create the foreign key "Becons_Clients" with the SET NULL referential action, because one or more referencing columns are not nullable.

I know how to solve them, but it is just better if they are validated or automatically applied to the referenced fields (the second one could give a warning when choosing 'Set to null' in the constraint editor.

Best regards,

Hugo
Back to Top
Ricardo View Drop Down
New Member
New Member
Avatar

Joined: 12 Jul 2010
Posts: 18
Post Options Post Options   Quote Ricardo Quote  Post ReplyReply Direct Link To This Post Posted: 21 Feb 2011 at 5:22am
Hi Hugo,

You are right, Data Modeler project validator should generate a warning for this type of relationship in SQL Server databases. We will include that.

Thanks,

--
Ricardo Samila
TMS Software Team
http://www.tmssoftware.com
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down