Field Data

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.

 

More:

Candidate Key Data