Index Tag Data

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.

 

More:

Set Integrity Data