isc_sqlcode()
Go Up to API Function Reference
Translates an InterBase error code in the error status vector to a SQL error code number.
Syntax
ISC_LONG isc_sqlcode (ISC_STATUS *status_vector);
| Parameter | Type | Description |
|---|---|---|
|
|
|
Pointer to the error status vector |
Description
isc_sqlcode() searches status_vector for a reported SQL error, and if it finds it, translates the InterBase error code number into an appropriate SQL error code. Typically, this call is used to populate a program variable (usually called SQLCODE for portability among SQL implementations) with a SQL error number for use in a SQL error-handling routine.
Example
The following code illustrates how isc_sqlcode() might be called in a DSQL application:
#include <ibase.h>
long SQLCODE;
ISC_STATUS status_vector[20];
. . .
if (status_vector[0] == 1 && status_vector[1]) {
SQLCODE = isc_sqlcode(status_vector);
isc_print_sqlerror(SQLCODE, status_vector);
}
Return value
If successful, isc_sqlcode() returns the first valid SQL error code decoded from the InterBase status vector.
If no valid SQL error code is found, isc_sqlcode() returns –999.