Subject | TableNames doublequoted??, why??? |
---|---|
Author | cgar1136 |
Post date | 2005-05-31T17:40:54Z |
Hi there...
i've found some databases where in the sentences i must double quote
the table and field names like this:
INSERT INTO "VENTAS" ("ARTICULO","CANTIDAD","ETC") VALUES
('XYZ',789','ETC')
but in another version of this database the sentences are acepted
without the double quoted... like this:
INSERT INTO PROPIEDADES (TIPO,PISOS,APTOS,ASCEN) VALUES ('E',10,32,3)
why happen this???... both databases uses the Dialect 3, and same page
size... wich is the factor that makes this behaviour??
Thanx in advance...
Carlos
i've found some databases where in the sentences i must double quote
the table and field names like this:
INSERT INTO "VENTAS" ("ARTICULO","CANTIDAD","ETC") VALUES
('XYZ',789','ETC')
but in another version of this database the sentences are acepted
without the double quoted... like this:
INSERT INTO PROPIEDADES (TIPO,PISOS,APTOS,ASCEN) VALUES ('E',10,32,3)
why happen this???... both databases uses the Dialect 3, and same page
size... wich is the factor that makes this behaviour??
Thanx in advance...
Carlos