Page 1 of 1

Cascade and Not Null

PostPosted: Sat Dec 24, 2016 12:03 am
by jimmytaker
It would be nice to be able to set the foreign keys to 'not null' (like it is possible to set a property 'not null').

It would also be nice to have the option to set the 'on update' and 'on delete' relationships to cascade and set to null.

Re: Cascade and Not Null

PostPosted: Sat Dec 24, 2016 1:29 pm
by qxorm
Hello,

to be able to set the foreign keys to 'not null' ... option to set the 'on update' and 'on delete' relationships to cascade and set to null

Do you want these options only for generated DDL SQL database schema ?

FYI, you can manage options which are not available in QxEntityEditor using meta-data feature (for an entity/property/relation/enum) : http://www.qxorm.com/qxorm_en/manual_qx ... ity_params
Then, all meta-data are available in the Javascript engine to customize exports (so you can customize DDL export for example), and are also available in C++ code : http://www.qxorm.com/qxorm_en/manual_qx ... _meta_data

Re: Cascade and Not Null

PostPosted: Sun Dec 25, 2016 1:56 am
by jimmytaker
Yes, I meant in the resulting generated SQL.

Excuse me, I do not understand this:
Then, all meta-data are available in the Javascript engine to customize exports (so you can customize DDL export for example)

I do not understand how to modify what appears in the generated SQL from within QxEntityEditor

Re: Cascade and Not Null

PostPosted: Sun Dec 25, 2016 3:05 am
by jimmytaker
Ok. The JavaScript engine. I guess that will work. Maybe I will get into it. I do not know. That appears a bit too much work atm.