Page 1 of 1

can't set a null-constraint on foreign key columns

Posted: Wed 28 Dec 2011 19:13
by mindplay
It appears there is no way to control NOT/NULL for foreign keys?

To be clear: in a one-to-many relationship, I can't find an option that will make the foreign key column NOT NULL in the generated schema.

Am I missing something?

Posted: Thu 29 Dec 2011 10:09
by Shalex
Please press the [...] button in column editor to set all column attributes.

Posted: Thu 29 Dec 2011 16:21
by mindplay
Found it, thanks!

To be clear: I double-click the association to open the association-editor, then select the column in the "columns mapping" list below, and then the "..." button reveals.

(perhaps consider making this visible on the property-grid somehow?)

Posted: Tue 03 Jan 2012 15:04
by Helen
Thank you for your suggestion.
We will investigate the possibility of implementing this functionality. But there is no timeframe at the moment.