@dblookup and string key problem

HCL Domino Domino Forum
1

I try to get by @dblookup response documents from a single main document. Application is quote form. Main document is the header of the quote and each item on quote is a response document. I try to get response document for a specific with a key that is a numeric-incremental number (converter in text string). I use this formula in a Dialog List:

@DbLookup(“”:“”;“notes/mcj/ca”:“programmation\commandes.nsf”;“($$Soumissions\éléments-prgm)”;“100004”;6)

My first column of the view is the string converted quote number (like "100002,100003,…)

When I execute the formula, I get “Key must be a string”. I checked my ($$Soumissions\éléments-prgm) view and the first column return correct value. To be sure that the first column is a string, I do a @Text(columnvalue.

2

Subject: @dblookup and string key problem

I’ve never heard of a “key must be a string” error and I thought I’d seen them all. The fact is, the key need not be a string (regardless of the datatype of the sorted column), so the error doesn’t make any sense. Even if the datatype didn’t match, you shouldn’t get “key must be a string” – you’d get an “entry not found.”

Are you certain that’s the exact error message? Can you post the exact words? Also, the formula you posted isn’t the actual formula on your form (obviously you don’t want to look up “100004” each time). Don’t assume that the error is coming from the @DbLookup. Provide complete information and people may be better able to help.