I receive this message while doing a DBLookup. I am trying to access a field outside the current database but on the same server. The path I am using is D:\Lotus\Domino\Data\Purchasing.nsf.
Any ideas why I would be getting this message?
Subject: Field: “Test1”:This Function Is Inappropriate For File System Directories
The path to the DB is not needed. Since it is on the same server, just specify “” as the database and “Purchasing.nsf” as the database.
Subject: Try: @DbLookup(“”; @Subset(@DbName; 1) : “Purchasing.nsf”; “View”; Key; Column)
As noted above all paths are relative to the Data Directory on the server.
Subject: Field: “Test1”:This Function Is Inappropriate For File System Directories
To whom it may concern, I had the same message error, and I found out what caused it.
I wrote a formula in a DialogList, in order to retrieve data from a view outside my db.
But, I would like to get data as faster as I could across local database and remote replica.
So, I wanted to find the nearest user’s server and its correct file.
But I made a mistake, and I wrote as following:
OU:=@Name([OU1];@UserName);
myServer:=@If(OU=“RJ”;“ucrg_srv_rj”;“ucrg_srv_sp”);
@If(OU=“RJ”;“aplicat/cadastro.nsf”;“aplicat/cadsp.nsf”);
@DbColumn(“Notes”:“NoCache”;myServer:myFile;“SysSiglaConsAdv”;1)
I forgot to define my myFile variable, which would refers to my database to open.
As I did the correct sintax, the error disappeared, as following:
OU:=@Name([OU1];@UserName);
myServer:=@If(OU=“RJ”;“ucrg_srv_rj”;“ucrg_srv_sp”);
------------------------------here--------
myFile:=@If(OU=“RJ”;“aplicat/cadastro.nsf”;“aplicat/cadsp.nsf”);
@DbColumn(“Notes”:“NoCache”;myServer:myFile;“SysSiglaConsAdv”;1)
Subject: Field: “Test1”:This Function Is Inappropriate For File System Directories
I could guess (like, maybe you’re using the full file system path, which is the wrong thing to do), but I can’t really tell without the formula. Post what you’re using and perhaps we can tell.