Accessing Oracle database using @DBLookup

[Noltmier]

I am trying to access an oracle database using the @DBLookup command. The problem I have is that I want to use a filed within my Form to use as the key.

@DbLookup("ODBC":"NoCache";"oracle";"";"";"E3XHST52";"XHQT02":"0";"XHITEM";upc01;"Distinct":"Ascending&quot

The key columd is XHITEM, and the field in the form is upc01. when I try to use this I get:

<Data Access Application Layer> Could not execute @db function

I can put an actual value and it works fine. But I want the user to be able to put values in the upc01 field and have it use that.

 

[shenglong]

u can check the &quot;add values not in list&quot; in the information tabbed sheet box to allow users to add in values and use them. hope it helps