I have two fields f1 and f2 in my notes client.
f2 gets its value via @dblookup using the value in f1 as key.
How can I implement the same in web?
I have two fields f1 and f2 in my notes client.
f2 gets its value via @dblookup using the value in f1 as key.
How can I implement the same in web?
Subject: @dblookup in web
I have done a similar lookup, with @DbColumn, for both the Notes client and the Web. Here’s my code:
Location := “”:“Folder\dbname.nsf”;
View := “myview”;
ColumnNumber :=1;
@If(@ClientType=“Notes”;
@Left(@DbColumn(“Notes”:“NoCache”;“Server1”:“Folder\dbname.nsf”; View; ColumnNumber); “-”);
@Left(@DbColumn(“Notes”:“NoCache”; Location; View; ColumnNumber); “-”))
I know it’s not exactly what you’re asking for (a DBLookup) but it shows you how I referenced the server and db over the web. Incidently, I was accessing a different database on the same server.
Subject: @dblookup in web
This should work even in the browser. Where exactly is the problem ?
Aniz