Discussion:
How to stop double quotes in column code from being quoted upon generation
(too old to reply)
ht1815
2011-07-28 17:38:06 UTC
Permalink
This is weird, I know, but I have a table with numeric column names,
e.g. 3000. The DDL for the table create statement needs to quote the
code, so that it comes out like "3000". If I don't put quotes around
the code in the column properties, the DDL reads 3000. If I quote the
column code, it reads ""3000"". Can I stop PDM from quoting quote
marks in column codes?
apander
2011-08-10 09:33:38 UTC
Permalink
Post by ht1815
This is weird, I know, but I have a table with numeric column names,
e.g. 3000.  The DDL for the table create statement needs to quote the
code, so that it comes out like "3000".  If I don't put quotes around
the code in the column properties, the DDL reads 3000.  If I quote the
column code, it reads ""3000"".  Can I stop PDM from quoting quote
marks in column codes?
Hi

If you go to the DBMS properties and change the property
CaseSensitivityUsingQuote to No then you should be fine.

Cheers
Al

Continue reading on narkive:
Loading...