Subject | Keyword as column name |
---|---|
Author | agentsinaction |
Post date | 2004-04-14T08:56:44Z |
Hello.
My problem is that a column name is a keyword for Firebird.
create table test (min varchar primary key);
I found out that this works:
create table test ("min" varchar primary key);
Using "select * from test" seems to work correctly. But how can I
select that column?
select min from test;
select "min" from test;
select test.min from test;
select "test.min" from test;
They all do not work.
Any idea?
JOERN_HEID
My problem is that a column name is a keyword for Firebird.
create table test (min varchar primary key);
I found out that this works:
create table test ("min" varchar primary key);
Using "select * from test" seems to work correctly. But how can I
select that column?
select min from test;
select "min" from test;
select test.min from test;
select "test.min" from test;
They all do not work.
Any idea?
JOERN_HEID