Trap Errors - Report C/AL Code

leikelman

I am running a report through the Job Queue which inserts/modifies records in the Item table. I am currently checking if an insert/modify was unsuccessful, but I want to know why the record I am trying to insert/modify was unsuccessfull.

I tried using the GETLASTERRORTEXT function, but that does not give me any information on the cause of the error for the insert or modify. An example of an error during insert would be a duplicate No. (Primary Key) value or an invalid field value for a CODE field, something along those lines.

Is there any way I can determine the cause of an error in NAV?

(ie. In VB6/VBscript you would use the Err object to get the Err.Number and Err.Description. Does anything like this exist in NAV?)

Thank you.

tinoruijs

leikelman wrote:

Is there any way I can determine the cause of an error in NAV?

With GETLASTERRORTEXT you already found one way to determine the cause of an error.
I think you have to create you're own function to get the right information out of the string that is given by GETLASTERRORTEXT...

DenSter

The function just retrieves the last error, and unfortunately not all error messages are as clear as we'd like them to be. You're going to have to develop some sort of check yourself and catch certain things before trying to insert, and even then you can't catch everything.