Catch Error Messages

[Guest llagrevol]

Hi,

Is there a possibility to :

When there is an error in the script , not display an error message on the workstation but log it for example with _FileWriteLog and resume the script.

Thanks

L Lagrevol

[trids]

Yep .. that's already available

All you need ot do is check @error whenever it might get set, and call your UDF _FileWriteLog if @error is not zero.

Of course, design-time errors won't get trapped this way. Example: syntax errors, or when you refer to a variable as an array when it isn't an array. Runtime errors are what your UDF ceverly logs by checking @error.

HTH