Hi, thank you for your answer.

I wasn't aware that the dialect in which the database were created had any
influence on use of quotes and field names, when running queries in dialect
3, but that may explain my problem.

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

-
Svend

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 21. februar 2004 22:56
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Error when using quotes (")


At 06:24 PM 21/02/2004 +0100, you wrote:

>Hi I am getting the error below when I am using quotes in my query like
>this:
>
>CREATE TABLE TestTable ("ID" INTEGER, "Name" VARCHAR(30))
>
>If I leave out the quotes everything works fine:
>CREATE TABLE TestTable (ID INTEGER, Name VARCHAR(30))
>
>I am using FireBird 1.5 RC7.
>
>Error message:
>"The insert, update, delete, ddl or authorization statement cannot be
>executed because the transaction is inquiry only".
>
>How can this be?

Is your database dialect 1? Or do you have a dialect 3 database and a
dialect 1 client? That would explain the first part. (Dialect 1 doesn't
support quoted identifiers.)

The second part (wrong message) indicates that you are not using the
correct firebird.msg file at the client, or at the server if it is a local
connection.

/heLen





Yahoo! Groups Links