The lookup table has two fields, one of them is ADRC01, but when I use the function
It gives out "LOOKUP VALUECOL NOT FOUND"
The dbalias of the look up db exist....
SystemAdmin 110000D4XK301 Posts
Re: LOOKUP VALUECOL NOT FOUND2013-01-04T17:02:30ZThis is the accepted answer. This is the accepted answer.If you just created that column or table you may need to restart optim tool. It doesn't notice db changes realtime unfortunately.. If doesn't work, check your dbalias name.. It exists but you may be using wrong one :)