Incorrect datatype for database function

HCL Domino Domino Forum
1

Hello all:I am having this error while trying to lookup in a view I created in the names.nsf database

I use the following formula

@SetField(“Employee”; @DbLookup(“”:“”;@Command([FileOpenDatabase];@Command([FileOpenDBRepID];

“C22569F0:0053DA74”))

;@Command([OpenView] ;“Peoplebyid”);“EmpCode”; 1))

the view opens correctly,but no record is selected,my employee field is a text field

I caould not find this error any where,so can any one help

this is my second post

best regards

Dalia

2

Subject: Did you read any of the help on @DbLookup???

You do not pass @Commands as arguments to a @DbLookup@SetField(“Employee”; @DbLookup(“”:“”;@Command([FileOpenDatabase];@Command([FileOpenDBRepID];

“C22569F0:0053DA74”))

;@Command([OpenView] ;“Peoplebyid”);“EmpCode”; 1))

instead try

Field Employee := @DbLookup(“”:“”; “C22569F0:0053DA74”; “Peoplebyid”; EmpCode; 1);