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. |
