ODBC - where is the primary key?

HCL Domino Domino Forum
1

Hi,

I want to read data from a Lotus Server using the Lotus SQL driver.

Well, I can open a connection and read the metadata (Tables, Views, Columns).

I am a little confused. I looked at the the table “Person” and did not found a Primary Key. How should I get a specific record?

Thanks

Christian

2

Subject: RE: Primary Keys

Notes isnt a relational database system. But keeping it simple, you would use the first sorted column of the notes view you are looking at, this would be your primary key in Notes.

Alan

3

Subject: not sure

I’m not a developer by any stretch but seeing as though Notes dbs aren’t relational dbs, I’m not sure they would have a primary key.