|
<< Click to Display Table of Contents >> VCHKDesc (validity check) |
  
|
|
<< Click to Display Table of Contents >> VCHKDesc (validity check) |
|
The VCHKDesc structure provides information about validity checking constraints on a field (Paradox, dBASE, and SQL tables only), using the following fields (bRequired is the only option supported by the SQL):
Field |
Type |
Description |
iFldNum |
UINT16 |
Specifies the field number (1 to n). For dBASE, can be zero, where the szPict will then be checked for an expression to be used in the validity check. |
bRequired |
BOOL |
Specifies whether or not the field is required: TRUE, FALSE. |
bHasMinVal |
BOOL |
Has minimum value: TRUE, FALSE, or TODAYVAL. |
bHasMaxVal |
BOOL |
Has maximum value: TRUE, FALSE, or TODAYVAL. |
bHasDefVal |
BOOL |
Has default value: TRUE, FALSE, or TODAYVAL. |
aMinVal |
DBIVCHK |
Specifies the minimum value. |
aMaxVal |
DBIVCHK |
Specifies the maximum value. |
aDefVal |
DBIVCHK |
Specifies the default value. |
szPict |
DBIPICT |
Specifies the picture string. |
elkupType |
LKUPType |
Specifies the lookup type. (Only for Paradox) |
szLkupTblName |
DBIPATH |
Specifies the lookup table name; for information only. |