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.