Subject | RE: [ib-support] uppercase and double quotes |
---|---|
Author | Jordi Gálvez |
Post date | 2001-04-11T09:43:43Z |
Nando,
CREATE TABLE "empleado" (
"dni" INTEGER NOT NULL,
"nombre" VARCHAR(50));
then I get error when:
select * from empleado
and works when:
select * from "empleado"
according to this, it seems that the quotes are part of the name, I mean
they are valid characters for the name of the table. If so, there should be
a difference between "empleado" with quotes and empleado without them. But
then, why at IBExpert when I enter the name empleado (whitout quotes) in the
table name field, then IBExpert generates a create table statement as
create table "empleado"
with quotes in the table name?
The question is, is the same a table name with quotes and without it? if
it's not, then I don't understand the IBExpert behaviour, but if it is, then
I don't understand why it gets me the error when I declare the table with
quotes and do the select without them.
Maybe I'm confused at some point? what is the real meaning of quotes at
table name?
Jordi
> to me, it is exactly as designed/implemented/advertised.I think I'm a bit confused, the statement created by IBExpert is:
> What is it exactly that you find wrong in the results?
CREATE TABLE "empleado" (
"dni" INTEGER NOT NULL,
"nombre" VARCHAR(50));
then I get error when:
select * from empleado
and works when:
select * from "empleado"
according to this, it seems that the quotes are part of the name, I mean
they are valid characters for the name of the table. If so, there should be
a difference between "empleado" with quotes and empleado without them. But
then, why at IBExpert when I enter the name empleado (whitout quotes) in the
table name field, then IBExpert generates a create table statement as
create table "empleado"
with quotes in the table name?
The question is, is the same a table name with quotes and without it? if
it's not, then I don't understand the IBExpert behaviour, but if it is, then
I don't understand why it gets me the error when I declare the table with
quotes and do the select without them.
Maybe I'm confused at some point? what is the real meaning of quotes at
table name?
Jordi