| Subject | Why the table name & column name must with double quote? | 
|---|---|
| Author | jwdongcn | 
| Post date | 2003-05-30T01:39:24Z | 
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?
Thanks.
            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?
Thanks.