@DBLookup is a Formula language command frequently used for Lotus Notes Domino application development. It's often used several times within a single Notes/Domino application. If you'd like to return a field value from a
Related resources from SearchDomino.com:
Do you have a specific @DBLookup question? Ask our expert, Andre Guirard!

Check out our @DBLookup Fast Guide for more tips and expert advice.

You can also visit our Formula Language Reference Center for more resources.
specific Lotus Notes database, @DBLookup is the command to use. Here, we've compiled our top five @DBLookup tips. Discover @DBLookup code equivalents in Ajax, JavaScript and LotusScript, and learn a workaround for a common @DBLookup error.

#1. @DBLookup and @DBColumn for all browsers using Ajax
This generic code can be used to perform @DBColumn and @DBLookup using Ajax in Internet Explorer, Mozilla and Netscape.

#2. @DBLookup function for the Web using JavaScript
Learn how to simulate the @DBLookup function in a Web browser to return a Lotus Notes Domino array using some JavaScript code.

#3. JavaScript version of @DBLookup and @DBColumn
Learn how to get @DBLookup and @DBColumn functionalities with this JavaScript that will help you to avoid page refreshes while looking up data in a Web browser.

#4. LotusScript equivalent of @DBLookup and @DBColumn
SearchDomino.com member Nithya K. shares a LotusScript code equivalent of @DBLookup and @DBColumn for Lotus Notes that doesn't decrease Domino Server performance.

#5. Workaround for @DBLookup error: 'The specified database lookup generated more than 65,000 bytes of results'
It's common to receive this error message when performing an @DBLookup: "The specified database look-up generated more than 65,000 bytes of results, which is too large for Lotus Notes to handle in this context." SearchDomino.com member Vinay Betala explains how to use a "prompt method" with a multi-value selection option to work around this problem.

This was first published in October 2007

Back to top