Skip to main content
This forum is closed to new posts and responses. New discussions are now taking place in the IBM Developer Answers forum.
Information Mgmt
New to Lotus
How to buy
Live demos
Technical library
Forums & community
Java™ technology
Open source
SOA and Web services
Web development
My developerWorks
About dW
Submit content

developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum



PreviousPrevious NextNext

Michael Zens 9.Oct.07 05:49 PM a Web browser
Domino Designer 6.0.2 CF2 Windows XP

We have this code which is inteneded to search another database (DatabaseB) on the same server as the current Database (Database A) is on.

There is a field on a form in Database A called "RepID_mal". This field holds the replica ID of Database B.

The code for another field on the same form is:

viewvalues := @DbLookup("":"NoCache";repid_mal;"(group by requestor)"; @Name([Abbreviate];@UserName); "group");

@If(viewvalues = "";
@Return(@Prompt([Ok];"Error";"You cannot create a Request Document because you have not been set up as a requestor of any group. Please contact the Administrator to set up as a requestor for your group."));
status = "Draft";
@Elements(viewvalues) = 1; viewvalues;
@Prompt([OkCancelList];"Select your group / department"; "Please select your group / department"; ""; viewvalues));

Whave 3 servers which these db's are on. When we shut down serverA and ServerB and the users then use ServerC, the RepID_mal replica ID can not be found if the Icons on their workspace are stacked and the db icon is noot the top stacked icon, or they have not opened up the replica on ServerC yet. The get a "Server not responding.." error.

I was wondering if this would work:

viewvalues := @DbLookup("":"NoCache";@ServerName:repid_mal;"(group by requestor)"; @Name([Abbreviate];@UserName); "group");

By reading the Help DB it seems that it would still serach the desktop Icons first. Am I understanding this correctly?

Should I use This code instead (not preferred):

viewvalues := @DbLookup("":"NoCache";@ServerName:"DatabaseB.nsf";"(group by requestor)"; @Name([Abbreviate];@UserName); "group");

I would preferr not to use the last method because I setting it up for fail if the DB filename is changed or file path changes.

@DbLookupFailing (Michael Zens 9.Oct.07)
. . RE: @DbLookupFailing (Andre Guirard 9.Oct.07)

  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds


Forum use and etiquette
Native Notes Access
Web site Feedback

Lotus Support

 Lotus Support
IBM Support Portal - Lotus software
Lotus Support documents
Lotus support by product
Lotus support downloads
Lotus support RSS feeds


IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Connections Cloud Developers
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

Lotus Forums

 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
IBM Connections
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
Lotus Enterprise Integration
Lotus Protector
Lotus Quickr
Lotus SmartSuite