@DbLookup error

I'm trying to get info from the same database and even though the sintax and everything seems ok it won't work.  The error is:
Entry not found in index or view's index not built

Both fields are numeric and the formula is:
@If(Line = ""; ""; @DbLookup(""; ""; "Lines Code List"; Line; 3))
BlueGirlAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BlueGirlAuthor Commented:
Adjusted points to 50
0
PaebdbCommented:
Well, how about showing us the Formula you use ? We are no mytics.
0
BlueGirlAuthor Commented:
Edited text of question.
0
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

PaebdbCommented:
More questions:
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
0
PaebdbCommented:
More questions:
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
0
BlueGirlAuthor Commented:
I use it in a numeric computed field, the key in this form(Line) is a keywords field computed using an @DbColumn formula.

The key field in the view is not sorted, the column 3 is the one sorted in ascending order.
0
PaebdbCommented:
Did you try to make the key column sorted ?
Also try to rewrite the formula a little, maybe like this:

_Result:=@DbLookup("":"NoCache";"":"";"Lines Code List";Lines;3);
@If(@IsError(_Result);"- Nothing -";_Result)

Of course I assume that the field Lines has no multiple values and the view "Lines Code List" exists with this name.
0
BlueGirlAuthor Commented:
Lines has multiple values
0
PaebdbCommented:
The view must contain a sorted column in order for the lookup to work; otherwise a null value is returned. Results are not accurate for a multi-value field that is sorted but not categorized.
Next, if you use a multi-value field as key you will most liked get a list of text values. So the field this formula is used should be able to use multivalues too.
Did you try to write the formula as above ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BlueGirlAuthor Commented:
thanks a lot but I had to do some other changes in order for it to work, changes to the field type, the formula I had worked ok.  I solved the problem already.
0
stampCommented:
Hi BlueGirl,

I think for 50 pennies you let the whole machine work,
ant then say: sorry gays, it was nothing.

Give your dammed tippo to the forum or do not expect
the next time all friendly gays are hunting for you!

Kindly,
stamp
0
BlueGirlAuthor Commented:
That's not true.  I did solve it with the help of my supervisor not the one he gave me, with that one it didn't work.  The formula I had worked fine, the problem was the field types.  I'm new at this and don't know too well of how this works, I'm sorry if I did something wrong.
0
PaebdbCommented:
Well, nevermind, you didn't do anything wrong.
I see my participation here for helping people and not for hunting points.
I think  I also mentioned that your formula will return a text value list, and so might be a problem in a numeric field, but the most important thing is that you got your job done.
The only point for your next question:
tell us all details immediately please, we all have a regular job and not the time to ask for each detail that might be obvious for you.

Happy chrismas to all of you, I'm done for today ...
0
BlueGirlAuthor Commented:
Thanks Paebdb for being fair to me and understanding i did not knew how this worked.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.