Kbase P159029: Error-Status:Error does not report SQL server ODBC errors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/22/2010 |
|
Status: Unverified
SYMPTOM(s):
Error-Status:Error does not report SQL server ODBC errors
None of the errors were reported
Occurs in 10.1B, 10.1C, 10.2A
FACT(s) (Environment):
Does not occur in releases prior to 10.1B
Windows
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2A
MS SQL DataServer
CAUSE:
Bug # OE00194794
FIX:
The bug is fixed in 10.2B.
Use following workaround if bug fix is not available
check both error-status:error and error-status:num-messages attributes for errors
=====================================
DEFINE VARIABLE handle1 AS INTEGER NO-UNDO.
RUN STORED-PROC send-sql-statement handle1 = PROC-HANDLE NO-ERROR
("SELECT name, address, city, state, postal_code
FROM customer WHERE credit_limit >= 500").
IF ERROR-STATUS:ERROR OR error-status:NUM-MESSAGES > 0 THEN DO:
MESSAGE ERROR-STATUS:NUM-MESSAGES SKIP
ERROR-STATUS:GET-MESSAGE(1) SKIP
ERROR-STATUS:GET-MESSAGE(2) SKIP
ERROR-STATUS:GET-MESSAGE(3) SKIP
ERROR-STATUS:GET-MESSAGE(4) SKIP
ERROR-STATUS:GET-MESSAGE(5) SKIP
VIEW-AS ALERT-BOX.
END.
CLOSE STORED-PROC send-sql-statement WHERE PROC-HANDLE = handle1