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.
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



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

Notes/Domino 6 and 7 Forum

developerWorks

  

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";
@If(
@Elements(viewvalues) = 1; viewvalues;
@Prompt([OkCancelList];"Select your group / department"; "Please select your group / department"; ""; viewvalues));
group)

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
Author
Category
Platform
Release
Advanced search

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

Resources

 Resources
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

Wikis

 Wikis
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