I use lookup often, but rarely lookupall and even more rarely any of its variants. I can’t figure out what I’m doing wrong here. The first line of code works: I see two items, separated by a paragraph break. The second line of code gives me “Parameter contains an error.” The only difference in the parameters is the sixth parameter, which is a space enclosed by quotes, exactly like the example in the documentation.
displaydata lookupall("SubWizard",«OrderNo»,OrderNo,«Item to Ship»,¶)
displaydata lookupalldouble("SubWizard",«OrderNo»,OrderNo,«Item to Ship»,«Qty»,¶," ")
OrderNo is a text field in both databases–I specifically changed it to a text field in order to get this lookup to work.
Item to Ship and
Qty are both numbers, but I don’t think that should matter. In any case, I tried converting them to strings like so, and get the same error:
displaydata lookupalldouble("SubWizard",«OrderNo»,OrderNo,str(«Item to Ship»),str(«Qty»),¶," ")