Subject RE: [firebird-support] API Error constants was RE: [] Error when using quotes (")
Author Svend Meyland Nicolaisen
>>Regarding the interpretation of the status vector. I am using the message
>>file which were installed with FB 1.5 RC7. The funny thing is that if I
use
>>"isc_sqlcode" and "isc_sql_interprete" I get another interpretation than
if
>>I use "isc_interprete".
>
>They are three different functions, each transporting different levels of
>information. For details, consult the API Guide.
>
>
>^heLen

I have consultet the API guide. If I did understand you correctly, the error
message i got ("The insert, update, delete, ddl or authorization statement
cannot be executed because the transaction is inquiry only") were invalid in
the context of my specific problem. I got the error message by calling
"isc_sqlcode" and "isc_sql_interprete". (isc_sqlcode returned -817).

I then tried to use "isc_interprete" instead. This returned the following
three error messsages:

"Dynamic SQL Error"
"SQL error code = -817"
"Metadata update statement is not allowed by the current database SQL
dialect 1"

Now this error message fits my problem but shouldn't
"isc_sql_interprete(-817)" also return a valid error message like "Metadata
update statement is not allowed by the current database SQL dialect 1"?

Thanks again for your help.

-
Svend