#3 use quotes for item names (tables & columns)

open
nobody
5
2012-12-08
2012-04-17
Anonymous
No

please add a function to set item names in quotes. then it's possible to use keywords as column names e.g. window (postgres, apache derby, hsql)

sample:
without quoted names the following statement returns a syntax error, pointig on column WINDOW:

CREATE TABLE JAVISDB_RWINDOW
(
NAME varchar(30) NOT NULL,
COPYNUM decimal(22) NOT NULL,
UNDOLEVEL decimal(22) NOT NULL,
WINDOW varchar(40),
DEVICE varchar(30) NOT NULL,
FIGURE varchar(30)
)
;

result with quoted names (no error):
[QUERY ] CREATE TABLE "JAVISDB_RWINDOW"
(
"NAME" varchar(30) NOT NULL,
"COPYNUM" decimal(22) NOT NULL,
"UNDOLEVEL" decimal(22) NOT NULL,
"WINDOW" varchar(40),
"DEVICE" varchar(30) NOT NULL,
"FIGURE" varchar(30)
)

Discussion