This content has been marked as final. Show 2 replies
Budjum wrote:Should work if done properly. Look very carefully on the values you are searching for - are you trying to find the '1' you started with, or are you searching for the new value 'ONE'?
Could you please suggest what can be a reason of the problem:
While data import and doing table lookup all works fine untill the column with Key value is numeric (such as surrogate PK) but if i'm trying to use varchar NK - lookup doesn't work.
It simply doesn't find the loookup value without any additionall error.
. . .
But if DICT_ID will be changed to varchar2(20) and will contain character values like below, same import flow doesn't work:
IDs usually work better as numbers. Fewer cycles for the CPU to process
I know that it should work, but it doesn't :(.
Idea is - and you can easely test it - once your key column is not numeric but character lookup doesn't work.
It's work fine if you have 1,2.... in table as ID and trying to find it by Desc 'one,two...', but if you have 'ONE,TWO...' as ID lookup is failed.
Unfortunately can't use numbers...
Edited by: Budjum on 03.01.2013 22:47
Edited by: Budjum on 04.01.2013 6:33