IBM Lotus Domino Designer 8.5
  Versions 8.5 and 8.5.1

Examples: @DbColumn (ODBC data source)

1. This formula retrieves from the inventory database the complete list of colors in which your company's uniforms are available. The data is stored like this:

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

Use @DbColumn to retrieve the entire contents of the Color column (column 3):

@DbColumn("ODBC";"INVENTORY";"";"";"UNIFORMS";"Color")

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

Red:Green:Red:Yellow

2. This example uses the sample "pubs" database that is included with Microsoft SQL Server. The formula uses the ODBC SQL Server driver to access the database, locate the table called "authors" that is owned by user "dbo," and then retrieve the list of names in the "au_lname" column. The author names are sorted in ascending order; null values are discarded.

@DbColumn("ODBC";"PUBLISHERS";"dbo";"vanilla";

"dbo.authors"; "au_lname":"Discard";"Ascending")

---

Library | Support | Terms of use |

Last updated: Monday, October 5, 2009