Is there a way to pass a custom error number and text to the BCA log? After I use error handling in a VBA routine I’d like to show the job as failed with my message replacing the “(303) Error with no ErrorHandler…” message.
Thanks,
I don’t know about passing it to the BCA log. What we do is have a simple error log routine which writes to a separate file. Whenever I see a (303) error I know I can look in this file and it will have captured and error code and description - might be easier taking this approach then trying to interface with the main BCA log file.
I think that you can use Err to raise user defined errors. I tried looking through the help file just now, and it wasn’t clear whether or how to specify your own error code, but I’m fairly sure that it can be done. Maybe that will be enough to get you started.