Solved

Is Lotus Database has primary key for its field?

Posted on 2002-06-19
5
623 Views
Last Modified: 2013-12-18
Hello, I am very new to Lotus. When I create a field, I can see any primary key for me to define.

Why? where is the primary key? Lotus do not need key?
0
Comment
Question by:realman1
5 Comments
 
LVL 5

Accepted Solution

by:
gbentley earned 20 total points
ID: 7092078
Lotus Notes is not a relational database and therefore does not follow the relational rules. Hence, no tables, no relations, no joins, no primary key, no foriegn keys, etc.

It identifies documents by a document_id field that is included by default.

Hope that answers the question.
0
 
LVL 9

Expert Comment

by:Arunkumar
ID: 7092257
The only product that handles unstructured data - structured...

;-)
Dont never ever relate to any RDBMS and you are done there!
0
 
LVL 8

Expert Comment

by:Jean Marie Geeraerts
ID: 7092362
gbentley got it right on the nose.
Notes is not setup to be a relational database and therefore no keys are defined.
If you want to search a notes database, you create an index and use full-text index searching to find documents in the database.
In the full-text search you can search on any value of any field, a combination of fields, etc...

Lookup full-text search in the help database to find out more.
0
 

Author Comment

by:realman1
ID: 7092413
Thank you, guys. :)
0
 

Author Comment

by:realman1
ID: 7097587
Thank you, guys. :)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question