@DBLookup

I seem to struggle everytime I use this @Function.

I am trying to lookup from one database to another using the following code.

TempA := @DbLookup(“”; “”; “vwFldMgmt”; “Server”; 3);

TempB := @DbLookup(“”; “”; “vwFldMgmt”; “Folder and File Location”; 3);

TempC := @DbLookup(“”; “”; “vwFldMgmt”; “Database Name”; 3);

Temp1 := @DbLookup( “” ;“”; “DevHO1” : “SRM\Feedback.nsf” ; “Project Profiles” ;TempC; 2);

For some reason this lookup on Temp1 will not work! I get that lovely error “A view in that name cannot be found in this database” Well it does!

So I tried to hard code the Server, Path, Filename & View.

But nothing - Anyone see anything?

Subject: @DBLookup

Scott,

Need a colon rather than a semi-colon after the first parameter

Therefore Notes probably is looking for a view called “Server” :slight_smile:

HTH

Mike

Subject: RE: @DBLookup

UGH!

THANK YOU

Subject: RE: @DBLookup

Spotted it through bitter experience!!!

“If I had a penny for everytime I’d done it”…etc etc