Update and Add record into NotesDatabase

Hi, I’m new comer in the Lotus Notes & Domino.And I always confusing with the Notes Document and form.

Now the problem that i facing is I don’t know how to update and add record/document into NotesDatabse. Becuase if the *.nsf containing too many documents or forms I don’t how to point to the documents or form that I need.

Could anyone help me on that.

Thanks

Iris Lisa :wink:

Subject: Update and Add record into NotesDatabase

Hi!

A) A Notes document is a piece of data devided into fields or items

B) A Form is a mask or some kind of input/output tool to create/edit/display Notes documents.

C) Don´t mess around with terms like ‘record’! Records are used by relational databases - this has nothing to do with Domino/Notes

D) You can edit a Form in Domino Designer

E) You can create/edit/display a document using a form in Notes Client

F) Also you can use forms via the web to create/edit/display documents

Hope this helps to make things a little clearer. Please consider to work through one (or maybe some?) book(s) on Domino/Notes to understand the basics?

Greetings, Rolf

Subject: RE: Update and Add record into NotesDatabase

Hi Rolf,Thanks for your advise. Now I’m clear on the Notes Concept.

Anywhere, I still facing one problem on the NotesDatabase.

Below is my sample VB code. Please comment.


Dim s As NotesSession

Dim db as NotesDatabase

Private Sub Form_Load()

Set s = New NotesSession

Call s.Initialize

Set db = s.GetDatabase(“d015/d015”, “testDB.nsf”)

End Sub


Private Sub cmd_Add_Click()

Dim doc As NotesDocument

Set doc = db.CreateDocument()

doc.Form = “form”

'from name here, but it always give me error of Object doesn’t support this property or method

doc.field1 = “text1”

doc.field2 = “text2”

'save the record

Call doc.ComputeWithForm(False, True)

Call doc.Save(False, True)

End Sub


I already spent 2 days to trouble shoot on this problem. I don’t know what is my mistake. But I confirm I putin the correct form name and field name.

Could you please advise.

Thanks

Iris

Subject: RE: Update and Add record into NotesDatabase

You said “my sample VB code” so I will assume you are working from VB. Look in the Domino Designer help for “Creating a session object”. This will tell you how to use COM to access Notes and Domino objects.

– Charles