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:
ItemSizeColor
ShirtSmallRed
SkirtSmallGreen
SweaterMediumRed
TrousersMediumYellow

2. This example uses the sample gpubsh 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 gauthorsh that is owned by user gdbo.h 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 gau_lnameh field are returned. The author names are sorted in ascending order; null values are discarded.
See Also