Solved

dblookup problem

Posted on 2004-08-11
8
674 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 125 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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