Subject | Re: [ib-support] uppercase and double quotes |
---|---|
Author | Nando Dessena |
Post date | 2001-04-11T09:12:28Z |
Jordi,
What is it exactly that you find wrong in the results?
--
____
_/\/ando
> CREATE TABLE "empleado" (to me, it is exactly as designed/implemented/advertised.
> "dni" INTEGER NOT NULL,
> "nombre" VARCHAR(50));
> select * from EMPLEADO => ERROR!
> select * from empleado => ERROR!
> select * from "EMPLEADo" => ERROR!
> select * from "EMPLEADO" => ERROR!
> select * from "empleado" => WORKS!
>
> But if database objects are declared without double quotes:
>
> CREATE TABLE empleado (
> dni INTEGER NOT NULL,
> nombre VARCHAR(50));
> select * from EMPLEADO => WORKS!
> select * from empleado => WORKS!
> select * from "EMPLEADo" => ERROR!
> select * from "EMPLEADO" => WORKS!
> select * from "empleado" => ERROR!
>
> What happens? is it an Interbase bug or the problem is in IBExpert or maybe
> the Gemini ODBC?
What is it exactly that you find wrong in the results?
--
____
_/\/ando