?
Solved

dblookup problem

Posted on 2004-08-11
8
Medium Priority
?
677 Views
Last Modified: 2013-12-18
Hello All,
This is crazy.  I have worked with dblookup many times and I can't find the problem with this one.  Possibly the view.
I have a view that consists of data from 2 different forms.  The columns contain data from both forms.  here is my dblookup formula.
temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error";temp)

CCestXref is the view used.  Column 1 is sorted and contains change control numbers.  CCres_CCnum is the key I'm using on my 3rd form.  I'm looking to take all the values in column 3 of the 2 form view and place those values in the field containing this lookup on the 3rd form.  I keep getting lookup error. ??????
Please Help !!
Thanks !
Paul
0
Comment
Question by:pratigan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 4

Author Comment

by:pratigan
ID: 11776650
Additionally...
The field on the 3rd form that contains the dblookup formula is a computed field allowing multi values and compute after validation.
Hope this helps.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 11776656
WHich lookup error are you getting?

If you open the view and type the key you are trying with, does it go to that row?

Does the matching row have an error value displaying in the view?  If there are multiple matches, check that:
1) None of them has an error displaying in the view
2) All have the same data type
3) Dn't forget that a blank number or blank date is a string, so if the datatype is, e.g., number, and one doc has true numbers but another has blank numbers (null strinG), you will not be able to look this up.
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 500 total points
ID: 11776672
To get the text of the lookup error, replace:

temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error";temp)


With:

temp := @DbLookup("Notes":"NoCache";"";"CCestXref"; CCres_CCnum;3);
@If(@IsError(temp); "lookup error:"+@Text(temp);temp)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Author Comment

by:pratigan
ID: 11776694
entry not found in index or views index not built.
0
 
LVL 4

Author Comment

by:pratigan
ID: 11776806
I understand that I get the error initially until I enter the lookup key number on the form, but then the field value should show up and the error go away once auto refresh fields.
0
 
LVL 4

Author Comment

by:pratigan
ID: 11777013
I got it. Ended up rebuilding the lookup view differently.  FOr having multiple fields from different forms I just listed those fields separated by a : and removed the test for what form it was.  The form didn't matter, I have the forms listed under the view selection area only now and it works great.
Thank You !
0
 
LVL 4

Author Comment

by:pratigan
ID: 11787058
Although I got it worked out, I'm still granting you the points for your help.  I will be posting another question looking for a simple export to Word keeping the same notes document format.
Thank You !!
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 11788304
Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question