Subject | Re: [firebird-support] Re: Firebird ODBC Driver Unknow Table Error |
---|---|
Author | Helen Borrie |
Post date | 2004-07-30T14:44:04Z |
At 02:23 PM 30/07/2004 +0000, you wrote:
situations where you have to use an illegal word or character as an
identifier.
Quoted identifiers are case sensitive, so you *can* do this:
create table "blah" (
"blah" integer,
"BLAH" varchar(10));
Because Firebird stores all *unquoted* identifiers in upper case, it will
allow you to refer to an upper case identifier without quotes. So this is
a legal query:
SELECT "blah", BLAH
from "blah";
But this isn't legal:
SELECT blah, BLAH
from blah
See, it's not really confusing at all, is it? :-))
/heLen
>Well, I recreated the table using isql and DIDN'T use quotedIt's an SQL standard which (Praise the Lord!) is totally optional except in
>identifiers. Brio and MS Access can now query the table with no
>problems. Why is FB so picky about quoted identifiers?
situations where you have to use an illegal word or character as an
identifier.
Quoted identifiers are case sensitive, so you *can* do this:
create table "blah" (
"blah" integer,
"BLAH" varchar(10));
Because Firebird stores all *unquoted* identifiers in upper case, it will
allow you to refer to an upper case identifier without quotes. So this is
a legal query:
SELECT "blah", BLAH
from "blah";
But this isn't legal:
SELECT blah, BLAH
from blah
See, it's not really confusing at all, is it? :-))
/heLen