The SDATADDIT.DBF table contains a record for each index tag of the tables, views and cursoradapters 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 |
|
cName |
Character |
10 |
Tag name |
|
cDescription |
Character |
100 |
Tag description (used in toolbar Order button form). |
|
mComments |
Memo |
|
Comments |
|
mExpression |
Memo |
|
Index expression |
|
mExpressionFields |
Memo |
|
Contains a comma-delimited list of the fields that are in the index expression. |
|
mForExpression |
Memo |
|
Index For expression |
|
nCandidate |
Numeric |
1 |
Indicates whether the tag has been specified as a Candidate tag in VFP. |
|
nDescending |
Numeric |
1 |
Indicates whether the DESCENDING clause of the SET ORDER command is used when the tag is used as the master tag. |
|
nNotUsed |
Numeric |
1 |
Used internally |
|
nPrimary |
Numeric |
1 |
Indicates whether the tag has been specified as the PK Tag in VPM Enterprise. |
|
nUnique |
Numeric |
1 |
Indicates whether the UNIQUE clause of the INDEX command is used when the tag is created. |
|
nVFPPrimary |
Numeric |
1 |
Indicates whether the tag has been specified as a Primary tag in VFP. |
|
nCreateTagInForm |
Numeric |
1 |
For views and cursoradapters, identifies whether the tag is created in the form’s Load method. |
|
nOrder |
Numeric |
1 |
Indicates whether to include the tag in the toolbar Order button form. |
|
nOrderChild |
Numeric |
1 |
Indicates whether to include the tag in the toolbar Order button form when an active form that displays the cursor is a Related Forms child. |