Solved

How to emulate a dblookup

Posted on 2004-09-02
2
322 Views
Last Modified: 2013-12-18
HI Guys

I have made a change and am nolonger using UNID for PArent Child relationship

I am using field value(Numbers)

I have a script
Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1) I need to now get the parent doc based on its prnumber
which is in the xxpr_link1

Set podoc = uidoc.Document
      Dim xxoldTotal1 As Double                        ' This PO when it was opened.
      Dim xxpr_link1 As String      ' Link to PR      from this PO.
      Dim prview As notesView
      Set prview = db.getView("VPRNUM")
      uidoc.Refresh
      
      xxoldTotal1 = podoc.oldTotal1(0)            ' Initial value of this PO saved in PostOpen
      xxpr_link1 = podoc.pr_link1(0)
      
      Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1)
      
      
0
Comment
Question by:imjamesw
2 Comments
 
LVL 13

Accepted Solution

by:
CRAK earned 500 total points
ID: 11968202
You haven't given us your true question or problem.

Just two lines that provide an indication:
   "I have made a change and am nolonger using UNID for PArent Child relationship"
and
   "Set prdoc = currentdb.GetDocumentByUNID(xxpr_link1)"

If xxpr_link1 does not represent a doc id, we're talking about a lookup by KEY.
Perhaps this one might help you out:

Set prdoc = <ViewInstance>.GetDocumentByKey(xxpr_link1)

Of course you neet to define <ViewInstance> first, like:

myView = currentDb.GetView("<name>").
Make sure to sort by key, just as you would for @DbLookup.
0
 

Author Comment

by:imjamesw
ID: 11968358
I was playing around with by key however I was using the wrong indicator

Not the the view name

Duuuhh
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now