The SDATADDF.DBF table contains a record for every field of every table, view and cursoradapter in an application. The table has the following structure.
Field Name |
Type |
Width |
Comments |
cPK |
Character |
48 |
PK field |
cFK_DDTV |
Character |
48 |
FK to SDATADDTV (Table, View or CA) |
cFK_DDF_SameAs |
Character |
48 |
FK to SDATADDF (Same As field) |
cFK_DDIT_RIFKTag |
Character |
48 |
FK to SDATADDIT (FK Tag) |
cFK_DDTV_RIRefTV |
Character |
48 |
FK to SDATADDTV (Parent RI Cursor) |
cFK_DDTV_RIValidTV |
Character |
48 |
FK to SDATADDTV (Validation Cursor) |
cDescriptionLong |
Character |
50 |
Label caption |
cDescriptionShort |
Character |
30 |
Grid header caption |
cName |
Character |
80 |
Field name |
cType |
Character |
1 |
Type |
mComments |
Memo |
|
Comments |
mDefaultCode |
Memo |
|
If nDefaultType = 3, the code in this field is executed to produce the default value. |
mErrorExpression |
Memo |
|
Error message expression |
mFieldValidationCode |
Memo |
|
If nIntegrityType = 5, the code in this field is executed to validate the value. |
mPostFieldValidation Code |
Memo |
|
The code in this field is executed after the value has passed the validation check. The code can change the value returned by the validation routine and/or define a message to be displayed. |
mPreFieldValidation Code |
Memo |
|
Code in this field is executed before the value is validated. This code can be used to prevent the value from being validated, determine the value to be returned by the validation routine and/or define a message to be displayed. |
mRangeIntegrityFrom |
Memo |
|
Range Integrity “From” value |
mRangeIntegrityTo |
Memo |
|
Range Integrity “To” value |
mViewSourceDatabase |
Memo |
|
For view fields, identifies the view source database. |
mViewSourceField |
Memo |
|
For view fields, identifies the view source field. |
mViewSourceTable |
Memo |
|
For view fields, identifies the view source table. |
nAuditTrailAdd |
Numeric |
1 |
Indicates whether the field should be included in the audit trail when a new record is saved. Default is 1, the field is included in the audit trail. |
nAuditTrailChange |
Numeric |
1 |
Indicates whether the field should be included in the audit trail when a changed record is saved. Default is 1, the field is included in the audit trail. |
nAuditTrailDelete |
Numeric |
1 |
Indicates whether the field should be included in the audit trail when a record is deleted. Default is 1, the field is included in the audit trail. |
nBlankOnCopy |
Numeric |
1 |
0 (field is copied), 1 (field is blanked-out/emptied), 2 (default value is generated) |
nDecimals |
Numeric |
2 |
Decimal positions |
nDefaultType |
Numeric |
1 |
1 (no default value), 2 (code – run code in mDefaultCode), 3 (generate key – runGenerateKey method of data handler object), 4 (generateGUID – run GenerateGUID method of data handler object) |
nIntegrityLevel |
Numeric |
1 |
1 (field validation), 2 (record save), 3 (both) |
nIntegrityOption |
Numeric |
1 |
1 (off), 2 (on), 3 (on/empty/null) |
nIntegrityType |
Numeric |
1 |
1 (Range), 2 (Set), 3 (Referential), 4 (Same As), 5 (Code), 6 (Not Empty/Null) |
nLockViewProperties |
Numeric |
1 |
For view fields, identifies whether this field’s data is updated when the Update Field Info utility is run. If 1, the field’s data is updated. |
nNaturalOrder |
Numeric |
3 |
Number indicating the field’s actual order in a table record. |
nPreSaveDefault |
Numeric |
1 |
Identifies whether the field’s default value is placed in the field upon the creation of the record (0, the default) or just prior to the saving of the record (1). |
nRIBypass |
Numeric |
1 |
If 1, causes the RI check for the field to be bypassed. The default is 0, the RI check is not bypassed. |
nRIDeleteRule |
Numeric |
1 |
RI Delete Rule, 1 (restrict), 2 (set null), 3 (cascade), 4 (no change) |
nRIUpdateRule |
Numeric |
1 |
RI Update Rule, 1 (restrict), 2 (set null), 3 (cascade), 4 (no change) |
nWidth |
Numeric |
3 |
Width |
cFormat |
Character |
30 |
Format |
mInputMaskExpression |
Memo |
|
Input Mask expression |
mMessageExpression |
Memo |
|
Message expression |
mToolTipExpression |
Memo |
|
Tool Tip expression |
mWhenExpression |
Memo |
|
When expression |
nHelpContextID |
Integer |
|
Help context ID that is placed in control’s HelpContextID property. |
nIntegrityAutoPicklist |
Numeric |
1 |
If 1, will cause the Picklist form to automatically come up when the field’s value fails the validation check. |
nIntegrityOverride |
Numeric |
1 |
Integrity override. If 1, allows user to override the validation of this field. |
nMaxLength |
Integer |
|
Maximum number of characters allowed in field. |