@DbLookup not working

HCL Domino Domino Forum
1

I am using the below code and it is not looking up the department number from the username for my helpdesk database. I am new to development since version5, so your help would be greatly appreciated.

dept =@DbLookup( “” : “” ; “” : “names.nsf” ; “($VIMPeople)” ; FromD; “Department”;1);

@If(@IsNewDoc & !@IsDocBeingSaved & !@IsDocBeingRecalculated ; dept ; Department)

2

Subject: @DbLookup not working

Guess the first thing to check would be to pur in @name([abbreviate];FromD) to assure the name is in the right format- and what purpose in the “1” doing?

3

Subject: RE: @DbLookup not working

I did the abbreviate but now I get the following error:

Field: Department Incorrect Datatype for database function

4

Subject: @DbLookup not working

You’re missing the colon in this… dept := @DbLookup(…-rich

5

Subject: RE: @DbLookup not working

Thanks, I put the COLON in but still keep getting error

6

Subject: @DbLookup not working

I would leave the 1 off of the end, and make sure that the FromD field contains the username in abbreviated format (username/org).

7

Subject: @DbLookup not working

assuming FromD is a Notes user name why not use

@NameLookup ( NOSEARCHING]; FromD; “Department”)

8

Subject: RE: @DbLookup not working

Paul,

What does the @NameLookup function do? I couldn’t find it in the NotesHelp. Is it a new function to version 7? Does it lookup in the current database only? In my form, i’m trying to lookup in the names.nsf

thanks,

sadia

9

Subject: RE: @DbLookup not working

it is new to release 5. it does a lookup to names.nsf

10

Subject: RE: @DbLookup not working

Thanks Paul, that worked very well! I really appreciate your help!