From: <an...@pa...> - 2003-10-21 20:39:28
|
I'm really sure if this is a bug or design. I have problem with objects name in mixed case. When I run a query for my object I just get an error telling me that either the table or column doesn't exist. I run Firebird 1.5 rc6, with both IBExpert and Firebird.net-provider. The errors I get is similar in both interfaces. Example. The table tbl_Test has the columns mKey and mValue. I'm trying to insert values into the table with: INSERT INTO "tbl_Test" (mKey, mValue) VALUES ('andre',12); And the error I get is; Dynamic SQL Error SQL error code = -206 Column Unkown. MKEY At line 1, column 25 But if I create a new table with only uppercase object names there is no problem running a query in mixed case. I really like to have mixed case object names. |