Pair.DBKeys Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > 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.

 

Example

This example groups the records.

 

With oProj.Pairs.Item(0)

   'row number of database heading

   .DBRow = 3

   'create primary key; column no. of source file

   .DBKeys = "2;3"

   'group records

   .DBoptions = DBOptionFlag_Group

End With