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