Subject | Re: Error messages - an area subject to improvement? |
---|---|
Author | Ian A. Newby |
Post date | 2001-03-01T09:42:45Z |
Hi All,
The worst error message I have encountered so far is the
dreaded "Arithmetic exception, Numeric overflow or String Truncation
error".
I have spent two days looking through a nested set of SQL, SP's,
Views and tables to identify which column in which table caused the
problem. (It turned out it was in a different table altogether
updated by a trigger!).
Anything that can be done to give more meaningful information in
error messages should be done.
Regards,
Ian Newby
The worst error message I have encountered so far is the
dreaded "Arithmetic exception, Numeric overflow or String Truncation
error".
I have spent two days looking through a nested set of SQL, SP's,
Views and tables to identify which column in which table caused the
problem. (It turned out it was in a different table altogether
updated by a trigger!).
Anything that can be done to give more meaningful information in
error messages should be done.
Regards,
Ian Newby