Lotus Notes FAQ Visit Our Sponsor!

How can I control whether the @Db Function returns a list?


If the @DbLookup key is valid for multiple documents, it will return a list. All @DbColumns will return a list (unless there is only one value in the Lookup View). If you want to return only one value, use
@Subset(@DB Function; 1)
or
@Subset(@DB Function; -1)
.
If you want the @Db Function to return a list to a field, make sure that "Allow Multi-Values" is checked ON.

Applies to Notes Versions: 3, 4, 4.5, 4.6, 5
Last Modified: January 6, 1998