Trace:
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
jvx:server:storage:dbcheck_constraints [2018/02/02 10:33] admin created |
jvx:server:storage:dbcheck_constraints [2020/06/29 13:32] (current) cduncan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTRANS~~ | + | ~~Title: Considering Check Constraints From the Database~~ |
| - | ~~Title: Considering Check Constraints from the Database~~ | + | |
| - | In addition to the use of [[jvx:server:storage:dbdefault_values|Default Values]] the restriction to **"allowed values"** is another advantage of JVx. | + | In addition to the use of [[jvx:server:storage:dbdefault_values|default values]], the restriction to **"allowed values"** is another advantage of JVx. |
| - | The "allowed values"for columns are usually defined in the database using check constraints. These are evaluated by JVx and assumed as so called allowed values. | + | The "allowed values" for columns are usually defined in the database using check constraints. These are evaluated by JVx and assumed as allowed values. |
| - | The constraints directly impact the user interface, as the user is only offered the allowed values in the form of Choice Cell Editors. | + | The constraints directly impact the user interface, as the user is only offered the allowed values in the form of choice cell editors. |
| == Example == | == Example == | ||
| - | Based on the example for [[jvx:server:storage:dbdefault_values|Default Values]], we define the following check constraints (Oracle Syntax): | + | Based on the example for [[jvx:server:storage:dbdefault_values|default values]], we define the following check constraints (Oracle Syntax): |
| - | <java sql> | + | <file sql> |
| alter table USERS | alter table USERS | ||
| add constraint USER_ACTIVE_CHECK | add constraint USER_ACTIVE_CHECK | ||
| Line 22: | Line 21: | ||
| </file> | </file> | ||
| - | Therefore the fields "ACTIVE" and "CHANGE_PASSWORD" can only contain "Y" or "N". | + | Therefore, the fields "ACTIVE" and "CHANGE_PASSWORD" can only contain "Y" or "N". |
| - | So that in the user interface the correct Choice Cell Editor is used, this must be defined. This is done globally by calling: | + | So that in the user interface the correct choice cell editor is used, this must be defined. This is done globally by calling: |
| <file java> | <file java> | ||
| Line 30: | Line 29: | ||
| </file> | </file> | ||
| - | A Choice Cell Editor from the ApplicationUtil has already defined for the values "Y" and "N". | + | A choice cell editor from the ApplicationUtil has already defined the values "Y" and "N". |
| The following methods can be used to disable the check constraints detection: | The following methods can be used to disable the check constraints detection: | ||