Svein,

At 12:23 AM 22/02/2004 +0100, you wrote:

> >>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.

The interpretation of the error codes into a text message depends on the
file firebird.msg. If you have the wrong message file at the server or the
client, the error codes will be correct but the message text may be
wrong. Make sure you have the *same* firebird.msg at both client and
server and, of course, the correct version for the server and client
versions. (Server and client versions must match each other, of course.)

Helen

>