You should always test the success or failure code (the SQLCode property of the Transaction object) after issuing one of the following statements in a script:
Transaction management statement (such as CONNECT, COMMIT, and DISCONNECT)
Embedded or dynamic SQL
Not in a DataWindow
Do not do this type of error checking
following a retrieval or update made in a DataWindow. For information
about handling errors in DataWindow objects, see “Handling DataWindow errors”.
Table 16-3 shows the SQLCode return values.
Value |
Meaning |
|---|---|
0 |
Success |
100 |
Fetched row not found |
-1 |
Error (the statement failed) Use SQLErrText or SQLDBCode to obtain the details. |
The string SQLErrText in the Transaction object contains the database vendor-supplied error message. The long named SQLDBCode in the Transaction object contains the database vendor-supplied status code. You can reference these variables in your script.
Example To display a message box containing the DBMS error number and message if the connection fails, code the following:
CONNECT USING SQLCA;
IF SQLCA.SQLCode = -1 THEN
MessageBox("SQL error " + String(SQLCA.SQLDBCode),&
SQLCA.SQLErrText )
END IF
