I have a view by the name of PhoneBookI have a button and 2 fields on a form, (Fields are “FirstName2” and “Phone2”)
The server is “DOM” and file name is PhoneBook.nsf…
My syntax for the button is:
inputName := FirstName2;
Phone22 =@DbLookup(“”; “” : “”; “PhoneBook” : “Names” ; inputName;1);
Phone2 = Phone22
What am i doing wrong?
Any help will be greatly apreciated
Subject: Error in @DbLookup parms and forgetting to use the FIELD assignment…
Try:FIELD Phone2 =@DbLookup(“”; “Server/Org” : “PhoneBook.nsf”; “ViewName” ; FirstName2; 1);
Subject: RE: Forgetting to use the FIELD assignment…
The problem was there was no error messege, it just didn’t do anything…
the “FIELD” helped, i got it working now, the look up works.
Thnx for the help
Subject: DBLookup
Tomas,
I guess your formula won’t work. It would definitely help if you’d post the exact error message.
From what I understand there are multiple syntax errors within your formula - this formula won’t execute properly.
Also, the last line should be written differently.
Try this one (and watch colons and semicolons!!): <formula assumes that the PhoneBook view is in the Phonebook.nsf database and that Phonebook.nsf is located in the server root.
inputname := FirstName2;
Phone22 := @DbLookup(“”:“NoCache”;“DOM”:“PhoneBook.nsf”;“PhoneBook”;inputname;1);
FIELD Phone2 := Phone22
I’ve got no idea why you have a parameter “Names” in your formula unless I overlooked something … Where is the PhoneBook view located?
Have fun,
Stephan Holowaty
Principal Certified Lotus Instructor SA&AD
IBM Certified Instructor Websphere App Server (SA)
IBM Certified Instructor Websphere Portal Server (SA)