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