At 01:39 AM 30/05/2003 +0000, you wrote:

>Hello!
>In my Database, this SQL is error:
>select * from tablename;
> it will cause a Table unknow error;
>This is all right:
>select * from "tablename";
>
>The same thing is happened in column name;
>I have to double quote every table name & column name in my SQL.
>
>My Enviroment:
>Firebird1.5 RC2 / Windows 2000.
>The database is created by EMS Interbase&Firebird Manager 3.
>
>What's the reason, and how to correct it?

The reason is that you have used the option to create database objects with
quoted identifiers - an option that is available to allow you to use
identifiers that contain spaces, or that need to be case-sensitive, or that
are the same word as a reserved word. IBManager might have decided to do
it this way automatically, if it detected that your legacy database had
such identifiers in place.

Really, its only usefulness is where you are migrating a database from
another RDBMS that permitted or required such things.

To correct it, you will have to rebuild your database *without* the quoted
identifiers, resolving any spaces or keywords. If you have some "illegal"
identifiers that you want to keep, it's OK to have a mixture of both quoted
and unquoted identifiers in your database, as long as you remember they are
there when you come to use them in queries...

heLen