Candidate Key Data

The SDATADDCK.DBF table contains a record for each candidate key in the tables, views and cursoradapters in an application. The duplicate candidate key check is performed when saving a new record or a record in which the candidate key value has been changed. 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_DDTV_View

Character

48

FK to SDATADDTV (Duplicate check view)

cDescription

Character

100

Description of candidate key

cViewVariable

Character

20

Duplicate check view variable name

mExpression

Memo

 

This expression is evaluated for the record being saved and the resultant value is placed in the view variable defined in cViewVariable. The view defined in cFK_DDTV_View is then used to perform the duplicate check.

 

More:

Data Sources Data