Previous Topic

Next Topic

Inhoudsopgave

Book Index

TableId and PrimKey

TablebleId en PrimKey values are used for setting key values. Every database table has a unique tableID. You can look it up in T_IsahTable. The Primkey value enables you to find a particular record in a table using its primary key field or fields. You can uniquely identify any record in the database with the TableId combined with the PrimKey. The following table shows several examples:

TableId

Description

Primkey example

3

Production file

"PD-08-0023"

12

Part

"Auto"

14

Part revision

"Auto|000"

924

Engineering item revision

"1209"

Note: Use double quotation marks "" for the Primkey value, even when the accompanying table field does not contain text. If applicable, use the separator "|" (pipeline) to separate multiple fields in a key value.