I am trying to access the value of SQLSTATE or SQLCODE after executing a SQL statement with SQLExec(). The return value from this tells me if it was successful. If not successful, I can use the AError() command to find the error. But what about instances such as a select statement that returns 0 records. I want to be able to check for SQLCODE equal to 100 for "No Data" or SQLSTATE equal to "02000" for "No Data". My understanding is that AError() is only populated if there is an error and I assume the error reported is the SQLSTATE code. Does anyone know how to retrieve these errors? Thanks in advance.
John Davidson
John Davidson