Errors from SQL Servers

Some SQL servers generate return codes distinguishing between error and warning conditions. If a server supports this distinction, then the "$ErrCode" reflected to the Zim Client-Server application also distinguishes between errors and warnings. Hence, the Zim "ON ERROR" and "ON WARNING" exception handlers can be used.

If the server does not support such a differentiation, then a Zim error condition is generated into "$ErrCode".

In either case, $SQLErrCode contains the actual SQL server error code and $SQLErrMsg contains the SQL server error message.