Lotus Domino Designer 8 Help - Examples: @DbLookup (ODBC data source)

FORMULA LANGUAGE

Examples: @DbLookup (ODBC data source)
1. This formula retrieves from the inventory database the complete list of colors in which company uniforms are available. The data is stored like this:

Item	Size	Color
Shirt	Small	Red
Skirt	Small	Green
Sweater	Medium	Red
Trousers	Medium	Yellow

To retrieve the entire contents of the Color column (column 3) for all records where the first sorted column (column 1, Item) contains "Shirt" or "Trousers":

@DbLookup("ODBC"; "INVENTORY"; ""; ""; "UNIFORMS"; "Color"; "Item"; "Shirt" : "Trousers")

Since multiple records contain at least one of the keys, the result is a list:

Red:Yellow

Values in the resulting list appear just as they were encountered in the database; they are not sorted and duplicate values are retained.

2. This example uses the sample “pubs” database that is included with Microsoft SQL Server. The formula uses an ODBC driver to access the data source called PUBLISHERS and locate the table called “authors” that is owned by user “dbo.” In this table, the values in the "state" column are compared with the values "CA" and "TN." For every record whose state field contains either "CA" or "TN", the values stored in the “au_lname” field are returned. The author names are sorted in ascending order; null values are discarded.

@DbLookup("ODBC";"PUBLISHERS";"dbo";"vanilla"; "dbo.authors";"au_lname":"Discard";"state"; "CA":"TN";"Ascending")

See Also

@DbLookup (ODBC data source)

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary