|
<< Click to Display Table of Contents >> View Validity Checks |
  
|
|
<< Click to Display Table of Contents >> View Validity Checks |
|
Validity checks is an inherent feature of the Paradox table design, but unavailable with dBASE tables except with dBASE 7 tables.
PdxEditor does not offer a means to change the value of validity checks (except +/- required), but will show the existence of all values in a table view mode.
Validity checks, if present, are linked to the individual field specifications.
In the example as illustrated the input picture mask is for an international 11 digit US telephone number with a standard notation:
+1-(650)-513-0514 requiring af field size of 17 characters.
Required field attributes as revealed in the Validity Checks display may not display in the PdxEditor Restructure Extended dialog, depending on how the reqired attribute has been created, as for example this Orders2.db table displayed below created with DBD7:
Illustration: Borland Database Desktop 7 setting the Default value for a modified DBDemos Orders2.db table.
Concerning use of the Paradox "Picture" validity check attribute (corresponding a Field input mask/edit mask), this may be dis-recommended in favour of a look up field design to comply with changing demands for the input mask.
Further, except for the Paradox and Borland Database Desktop applications, custom built paradox applications (as e.g. PdxEditor) usually disregard the in table Picture validity specs as defined by this Paradox syntax in favour of input masks based on Field object specs defined by the application rather than by the table, or by a lookup table design for a dynamically selectable pattern, e.g. for domestic vs. foreign contacts.
To clear validity checks, as well as referential integrity links, you may run a Restructure Fields Extended, whatever clearing/setting Required attributes or not.
The PdxEditor Restructure Basic (modifying only names and sizes/prec. of fields) will preserve Validity Checks as well as referential integrity.
Duplicating af table by the PdxEditor [Copy Table] feature (Paradox only) also will preserve all existing validity checks (though not ref. integrity).
See Copy Table.
__________________________