Subject Re: [ib-support] uppercase and double quotes
Author Nando Dessena
Jordi,

> CREATE TABLE "empleado" (
> "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?

to me, it is exactly as designed/implemented/advertised.
What is it exactly that you find wrong in the results?
--
____
_/\/ando