Hello to all
I have the following that i need to do, and can’t figure out how to get it to work correctly.
So here we go:
I have a Notes app that link to a Pervasive SQL database via ODBC. The link is working 100% no problem there.
The values is being populated but, i need to lookup values from one to another.
For example: I am looking for a value in the amount field so Product “Apple” has got three values in the Pervasive database which is store code “001”, “002”, “003” but for each of the store code’s it does have different amount’s. So i only want to retreive Product Apple with store code “001”'s amount.
Is there a way of doing it?
I was thinking something like:
@DbLookup( “ODBC” : “NoCache” ; “CMC2013new” ; “” : “” ; “” : “” ; “MultiStoreTrn” ; “LastPurchAmt” : “” ; “StoreCode” & “ProdCode”;“001” & “Apple”; “” : “Ascending”)
But the above does not return anything correct, is there another way of doing it.
Kind Regards
Heinrich