BlueGirl
asked on
@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))
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))
Well, how about showing us the Formula you use ? We are no mytics.
ASKER
Edited text of question.
More questions:
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
More questions:
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
- where do you use this formula ?
- is the view's column where you search for the key sorted ?
ASKER
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.
The key field in the view is not sorted, the column 3 is the one sorted in ascending order.
Did you try to make the key column sorted ?
Also try to rewrite the formula a little, maybe like this:
_Result:=@DbLookup("":"NoC
@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.
Also try to rewrite the formula a little, maybe like this:
_Result:=@DbLookup("":"NoC
@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.
ASKER
Lines has multiple values
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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
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
ASKER
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.
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 ...
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 ...
ASKER
Thanks Paebdb for being fair to me and understanding i did not knew how this worked.
ASKER