Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
jvx:server:storage:dbcheck_constraints [2018/02/02 10:34] admin |
jvx:server:storage:dbcheck_constraints [2020/06/15 12:09] cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
||
|---|---|---|---|
| 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 == | ||
| 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: | ||