Get started Bring yourself up to speed with our introductory content.

@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.

Published: 22 May 2007
@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:
»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.

Dig Deeper on Lotus Notes Domino Formula Language

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close