Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • Last Modified:

dblookup problem

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
pratigan
Asked:
pratigan
  • 5
  • 3
1 Solution
 
pratiganAuthor Commented:
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
 
qwaleteeCommented:
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
 
qwaleteeCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
pratiganAuthor Commented:
entry not found in index or views index not built.
0
 
pratiganAuthor Commented:
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
 
pratiganAuthor Commented:
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
 
pratiganAuthor Commented:
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
 
qwaleteeCommented:
Thanks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now