Can't get DBLOOKUP2 (or DBLOOKUP) to work on 7.9.5 Scribe

I simplified what I am doing to just using the SQL table that has what I want to dblookup on.

My forumla is:

DBLOOKUP2(S2 , S3 , " nwksql3 - temp", " SubMarketConversion", " PrimaryMarket", " SubMarket", " NewSubMarket" )

all 3 fields are nchar fields.

I keep getting the "Error executing formula.." from the Edit formula diagalog?

What am I missing? I kow the connection, table and fields are correct....

("nwksql3 - temp" is currently both my source and destination)

I also tried DBLOOKUP and got the same issue!

(and, are the spaces as the first character inside the quotes needed? All of the samples seem to be that way!)



(1) Answer