Navigation:  Object Model Reference > Pair Object > Properties >

Pair.DBKeys Property

Previous pageReturn to chapter overviewNext page

Returns or sets a semicolon delimited list of Column indices used as primary key for Database. String value.

 

Syntax

expression.DBKeys

expression. A variable representing a Pair object.

 

Remarks

The column no. of the primary keys of the Master file have to be entered, separated by semicolons.

 

Example

To use the 2nd and 3rd column as primary key.

 

With oProj.Pairs(1)

   'row number of database heading

   .DBRow = 3

   'create primary key; column no. of master

   .DBKeys = "2;3"

   'group records

   .DBOptions(syDatabaseGroup) = True

End With

 

 


See Also

Pair Object
Pair Object Members