ERROR MESSAGE
Top  Previous  Next

Special Condition

Syntax: SET ERROR MESSAGE Error# ON/OFF

Default: ON

SET ERROR MESSAGE Error# ON/OFF displays or suppresses a particular error message when a system error occurs.

You can selectively turn OFF any -ERROR- message(s) in your command file (very handy for debugging) by doing the following:

SET ERROR MESSAGE Error# OFF  

To turn it back ON:

SET ERROR MESSAGE Error# ON  

For example, to not see the:

-WARNING- No rows exist or the specified clause.  

You can do the following:

SET ERROR MESSAGE 2059 OFF  

This new feature has a limit of 50 -ERROR- numbers to set OFF and each one requires a separate command.

NOTE: Each turned OFF message must be turned back ON before turning it OFF again. If not, you'll get the error message.