@DBLookup lessons
@DBLookup is the most common function used by developers when creating Lotus Notes Domino applications. It is often used multiple times in a single Lotus Notes form or in several forms within an application. The focal point of the @DBLookup function is to return a field value from a specific Lotus Notes database document. Learn about @DBLookup's capabilities, common errors you may run into when using it, and how to code faster lookups for Lotus Notes and Domino.
RELATED INFORMATION:
»

    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts focused on Lotus Domino, Notes, Workplace and other related technologies.

    By submitting your registration information to SearchDomino.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchDomino.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Have a question about @DBLookup or Formula language? Consult our Domino development expert!
»For more resources, check out our Formula language Reference Center.
TIPS AND TUTORIALS------------------------------------------------------------------------------------------------------------
Coding faster lookups in IBM Lotus Notes and Domino
This IBM best practices guide teaches how to speed up Lotus Notes Domino applications through a stronger understanding and better usage of the @DBLookup function. Topics covered include trapping for errors, minimizing the frequency of your lookups and avoiding the pitfalls of dropdown lists.
Using @DBLookup parameters
Learn how to specify parameters and retrieve a key value.
Examples of @DBLookup
Discover several situations where you may want to implement the @DBLookup function. In the examples provided here, the specific parameters are set and used to return office telephone numbers and the status of a virus check.
@DBLookup errors
Several different scenarios involving @DBLookup errors are covered in this reference table. If you're using @DBLookup and receive either an "Entry not found in index" error message or retrieve a value from a field that doesn't exist, this guide will come in handy.
@DBLookup and @DBColumn questions and answers
This IBM FAQ offers quick answers to some commonly asked questions about @DBLookup and @DBColumn functions, including how to looking up a DocLink, employing multiple keywords, and using @DBLookup within rich-text fields.
An introduction to Formula language for Lotus Notes
While not solely about @DBLookup, this SearchDomino.com tutorial will give you a great introduction to Formula language for Lotus Notes Domino. From working with Formula keywords to using Formula operators, functions and commands, you'll learn everything you need to know to start scripting with Formula language.

This was first published in May 2007

Back to top