Hi All,
I’m facing this error “Field Does Not Exist” while using @DBLookUp in a computed field. One thing I wish to note is that when I tested the form locally, it works fine. But when I upload it to the server, the mentioned error message prompted.
I looked up some of the previous posts here in this forum and tried most of the suggested answers but still getting the same error.
How to solve this problem? Any help is greatly appreciated. Thanks
Subject: @DBLookUp Field Does Not Exist
Can you post your @Dblookup formula
Subject: RE: @DBLookUp Field Does Not Exist
I have searched our source code and the exact error message “Field does not exist” does not appear in it. Is that the exact error text? How do you know it has anything to do with your @DbLookup formula?
We need more information about what you’re doing and what exactly is happening. If you’re not sure what information to supply, the C R I S P Y document might help you.
Useful blog: Best Practice Makes Perfect
Subject: RE: @DBLookUp Field Does Not Exist
oh sorry the exact error message is “Field: field1: File does not exist”.
I think it’s the @DBLookUp problem is because the moment I deleted off the field1 or I make the field editable instead of computed, it no longer shows the problem. Or am I wrong?
my code is something like this:-
@DbLookup(“”:“nocache”;“”:@DbName;“viewname”; fieldtoSearchBasedOn;2;[FailSilent])
and it works well when I’m testing it on my local computer but once I upload it to the server, the error message occurs.
Subject: RE: @DBLookUp Field Does Not Exist
“File does not exist” indicates that the database portion of the formula is wrong. You have this:
“”:@DbName
which results in
“”:“”:path\filename.nsf
You should only have @DbName in the formula.
Subject: RE: @DBLookUp Field Does Not Exist
yeah…removing the “” in the “”:@DbName solves the problem.
I thought by putting “”:@DbName, the server part will automatically detect whether it’s local or server…
Subject: RE: @DBLookUp Field Does Not Exist
Actually, if you want to look up in the current database, just use “” – @DbName is not needed.
I’m not sure what functionality you envisioned behind “automatically detect whether it’s local or server”. What were you expecting it to do differently based on this determination? You just wanted to access the current database that they are using, right? Wherever it is? “” will do that.
Subject: RE: @DBLookUp Field Does Not Exist
Hi Andre,
I have seen some posts from you telling that “” should always work and that @dbname is not necessary, but the fact is that we have got this problem and we have solved this by using @dbname.
In fact we have a TeamStudio consultant in our office today (I guess you know about this company) and we have installed the latest version of their CIAO solution.
Well, in this CIAO database we have had this same issue. A @dblookup that is not working. Something like that:
@dbcolumn(“”:“[NoCache]”; “”; “View”; 1)
We have changed the “” with @dbname and it worked.
The error we were having was something like "… “A view of that name cannot be found in the specified database …”.
I don’t know why, but the fact is that this issue is happening to us and @dbname always solves it. In fact, I faced this error maybe 8 years ago, and since then, to avoid this errors, I always use this solution/workaround in my developments.
Maybe it is related with some caching, or with some settings in the domino server, or in the server’s names.nsf, or whatever, but it unfortunatelly happens …
Regards,
Paco.
Subject: RE: @DBLookUp Field Does Not Exist
Yeah…all i wanted is to access the current database that they are using, no matter where it is.
Thanks for the explanation/suggestion, y’all. I’ve learn something here. 
Subject: RE: @DBLookUp Field Does Not Exist
Help file does state that you can use value of an editable field as the key. This might be what you are seeing.
Subject: RE: @DBLookUp Field Does Not Exist
Hi,
You should not use @DbName in lookup formula…that will work only formula lang…
use this formula…@DbLookup(“”:“nocache”;“Server Name”:“Db Name with Path”;“viewname”; fieldtoSearchBasedOn;2;[FailSilent])
see the examples on Domino Designer help…@DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords )
i hope this will work.
Sree