Does anyone know if there is an internal amper function that returns the error message in WebFOCUS similar to &FOCERRNUM that returns the error number?

This message has been edited. Last edited by: Kerry,

Syntax: How to Retrieve an Error Message
FEXERR(error, 'A72')
where:
error - Is the error number, up to 5 digits long.
'A72' - Is the format of the output value enclosed in single quotation marks. The format is A72 because the maximum length of an Information Builders error message is 72 characters.

Example: Retrieving an Error Message
FEXERR retrieves the error message whose number is contained in the &ERR variable, in
this case 650. The result is returned to the variable &MSGVAR and has the format A72.

-SET &ERR = 650;
-SET &MSGVAR = FEXERR(&ERR, 'A72');
-TYPE &MSGVAR

The output is:
(FOC650) THE DISK IS NOT ACCESSED

or

-SET &FOCERRMSG = FEXERR(&FOCERRNUM, 'A72');

This message has been edited. Last edited by: Francis Mariani,

Thanks...this functions works for the most part. However, if the error message is "Table Not Found: TableXXX", it does not return the name of the table which is a part of the error message. It just returns "Table Not Found".

Yes, unfortunately the additional message info is not included - we all wish it would be.

Thanks! So then, I guess there are other error messages where this function does not return the additional part of the message?

Never does. People have discussed how to capture/trace/parse the WebFOCUS execution code and errors, but I think this is overkill - a user never wants to know why a report failed, they don't want the report to fail. I usually capture the error and display a message stating an error occurred.