Getting error text from @Dblookup?

Question

How do I return the error text from an @Dblookup? I have similar lookups that I suspect that are returning an error so I want to have a panel that displays when a lookup error occurs.

I have:

var dbpath = @DbLookup("","Setup","Setup","EIDBServerFilename");
var tmp = @DbLookup(dbpath,"FullName",@Name("[ABBREVIATE]" ,getComponent("inputTextEmpName").getValue()),"HRLogonID");
@If(@IsError(tmp),"Error= "  + @Text(tmp),"");

But I am just seeing "Error= " with no error text.

If I remove the @Text I get "Error = undefined".

How do I get the error message if it is an error?

I looked up both @IsError and @Dblookup in help but as usual the help is horrendous and does not even mention @Dblookup could return an error nor what to do about it.

Sven Hasselbach Sven Hasselbach · Accepted Answer · 2012-06-26T05:59:19

Errors from a @DbLookup in SSJS are internaly catched and will not returned.

This is because it is realized via session.evaluate, and if you make a bad @DbLookup in a session.evaluate, the full evalulation fails and you won't receive the error message of the @DbLookup.

In case of a bad @DbLookup, null is returned, and this is what you are testing with @IsError: tmp is null, this is why you get an undefined in your string.

If you make a @Text with a undefined value, an empty string is returned.

Hope this helps

Sven

EDIT:

If you run code in an evaluate statement you are able to get the error message. F.e. this

session.evaluate('lookup:=@DbLookup("";"";"X";"1";1);@if(@isError(lookup);@Text(lookup);lookup)')

would return the error message.

Getting error text from @Dblookup?

1 Answers