You have to check return value from SQLEXEC() and if it less than 0 (-1) use AERROR() to get detailed ODBC error info.

>The following does not trigger the CATCH block when a SQL error occurs.
>oException.ErrorNo = 0 even when a SQL error occurs. What am I doing wrong?
>
>

>oException = CREATEOBJECT("RFException")
>
>TRY
>	SQLEXEC(._iSQLConnHandle, sQuery, sTableName)
>CATCH TO oException
>ENDTRY
>
>IF ._HandleError(oException)
>
>	SQLEXEC(._iSQLConnHandle, "SELECT @@ROWCOUNT AS AffectedRows", "SQLTally")
>	iRowsAffected = SQLTally.AffectedRows
>
>	USE IN SQLTally
>
>ENDIF
>
>