Update a Document field in another Database on the same server

HCL Domino Domino Forum
1

Background: I am trying to update a field in the employee document in our employee database. I am atempting to do so via a script when the document is submitted but for some strange reason the script cannot find the document in the employee database. I have attached the script for your review.

Dim NotesSession As New NotesSession

Dim WorkSpace As New NotesUIWorkspace

Dim Db As NotesDatabase

Dim View As NotesView

Dim Doc As NotesDocument

Dim VacDoc As NotesUIDocument

Dim LkpName As String

Dim VacTaken As Currency

Set VacDoc = workspace.CurrentDocument

LkpName = VacDoc.FieldGetText( “ReqAuthor” )

VacTaken = Ccur(VacDoc.FieldGetText( “TotalDays”))

Set Db = New NotesDatabase( “”, “DbLookupL” )

Set View = Db.GetView( “EMPLookup” )

Set Doc = View.GetDocumentByKey(LkpName)

If Not (Doc Is Nothing) Then

Doc.datVacacionTaken_CY(0)= Doc.datVacacionTaken_CY(0) + VacTaken

Call Doc.Save( True, True )

Else

Messagebox "Employee " + LkpName, “Not found…”

End If

2

Subject: Update a Document field in another Database on the same server

Is the first column in the view in which you are looking sorted?

Also as you are searching for a name could it be that they are being stored in different formats. e.g. one is in the common format and the other canonicalized.

3

Subject: RE: Update a Document field in another Database on the same server

The first column is sorted but not categorized. The column contains the userid and its not canonicalized.

I hope you can help because this is driving me crazy for two days now.

4

Subject: RE: Update a Document field in another Database on the same server

Is the column the first column in the view? Check in designer that there are not any hidden columns.

If not then it must be a problem with the key as the column does not need to be categorised as you are only searching for a single key.

Run through the code in the debugger to check the exact value of the variable LkpName which you are using for the key. Then find the document that it should locate in the target database and check the field in the document properties to see if they are exactly the same.

5

Subject: RE: Update a Document field in another Database on the same server

The column is the first one in the view. I checked and there is no hidden columns. I verified the values and they are the same. To make things sound more stragne, I am using the same key in my dblookups to get data from the database and it works great. I was going to try and get the document ID and store it to my document when the document is created and see if that helps unless you have some other sugestions?Is it possible be locked from writing somehow? I am using a local copy and I am getting the same results.

6

Subject: RE: Update a Document field in another Database on the same server

The help does state a keyArray but then mentions String or array of strings as allowable parameters.

As a last throw of the dice you could try

Dim LkpName(0) As String

LkpName(0) = VacDoc.FieldGetText( “ReqAuthor” )

7

Subject: RE: Update a Document field in another Database on the same server

You could always try looping through the documents and manually comparing the key and the field value.

Shawn