Hi,

 

I have the following basic @DbLookup that needs to read some values off the person document.  In this instance, I just want the form name to keep it short and simple. 

 

Long term I will be setting some sessionScope variables, based on the login, however short term I just need it to work!  I do not know why it is failing.  Apologies for posting something so basic, but I can't get this to work.

 

I have done a lookup to another database - it works, seems to be the NAB, or a secondary NAB as is the case, where this is not working.  It does not work even if I set a hardcoded value instead of the @UserName() .  I'm stumped?

 

=====================================================================

var db = new Array(@DbName()[0],'names.nsf');
var tmp = @DbLookup(db, "($Users)", @LowerCase(@UserName()), "Form");

if (@IsError(tmp)) {
    return "Grrrr";
} else {
    return tmp;
}

=====================================================================

 

Thanks in advance...

 

Regards,

 

A