FailSilent Keyword In Lookups in Lotus Notes
we weren’t aware of the great new feature added to the @DbLookup function in Notes. The @DbLookup function now has an optional parameter at the end. This parameter takes one or more keywords in a list. I’ll describe these by showing an example.
Let’s say you have a view that translates letters into your “secret code”. The letter A becomes a Z, B becomes a Y, and so on. (Yes, an easy code to break, but that’s not the point). So, let’s say you’ve been doing a lookup using the value from the “Source” field as a key:
@DbLookup(“”; “”; “vwSecretCode”; Source; 2)
If the field has a value of “A”, then the lookup results in “Z”. But if the field has a value of “1″, then this will cause an error because you’re only translating letters. So you have to trap for this error.
Viewed 6122 times by 1515 viewers
