Dblookup is not working

HCL Domino Domino Forum
1

Hi all, what I want to do is very simple I don’t know why i can’t get it right

I have a view info: that contains 2 columns “detail” and “fee”

I have 2 fields in a form

“detail1” and “fee1”

I get the value of detail from the info view using a dialog list… now I want to have the fee1 field automatically get the corresponding fee.

I am using :

x:= dblookup(“”:“”; “”:“registeration.nsf”; “info”; detail1; 2);

@if(@iserror(x); “error”; x)

my database is local.

It keeps giving my the string “error” so my lookup is not working. Any advice? where is the best place to put this formula? Or even If there is a lotus script that can do that, I could use it… Already I am using a lotus script in the onchange of the detail1 field to refresh the hidden rules… and it works… so if i could add the lookup there too somehow??

It seems so simple…

Please advise,

Thanks

Jenny ?

2

Subject: Dblookup is not working

Try thisserver:= @ServerName;

dbname := @Subset(@DbName; -1)

x:= dblookup(“”:“NoCache”; server:dbname; “info”; detail1; 2);

@if(@iserror(x); “error”; x)

If for local, keep the server as “”

Good luck

William

3

Subject: RE: Dblookup is not working

Hi William, I tried that and I still get the “error” string,

I started this database from blank.

OH! my view is \info ! should it be “\info” i will test this now…

4

Subject: Field fee1: Entry not found in index or view’s index not built

HiI removed the iserror(x) to stop displaying “error” string, the error msg I get now is " Field fee1: Entry not found in index or view’s index not built" I think my look up is not accessing the view.

But when I use the same parameters (2, info) in dialog list selection It works so, the view does exist and does have values ??

Any advise?

Jenny

5

Subject: Found Solution!

I knew it would be something simple.The view needs to be catagorized to work right. Now it is working.

6

Subject: Dblookup is not working

The first thing I would do is change the first part to read @Dblookup(“”:“NoCache”;etc)That’s just a personal preference though.

Looking at the file name - is it definitely registeration.nsf - as opposed to ‘registration.nsf’?

The view name or alias definitely right?

These are a few ideas…

7

Subject: RE: Dblookup is not working

Hi Ben, I realized that i spell badly, but that is not the problem, because I copied and pasted the db name, from the db properties itself. So spelling mistake is not it.

Thanks for your reply