Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

dblookup problem

Posted on 2004-08-11
8
Medium Priority
?
681 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
Technology Partners: 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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 users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

618 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