Trace:
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
jvx:server:storage:dbcheck_constraints [2018/02/02 12:56] admin |
jvx:server:storage:dbcheck_constraints [2020/06/29 13:32] (current) cduncan |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~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): |
<file sql> | <file sql> | ||
Line 21: | 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 29: | 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: |