Page 1 of 1

CommandBuilder does not generate double quotes around case sensitive columns

Posted: Wed 08 Feb 2006 16:21
by Guest
Hello,

if a column is case sensitive like "aColumn" the CommandBuilder generates a insertstatement which contains the column name without double quotes which oracle not knows.

Is there a workaround for this ? I am using version CrLab.Oracle 3.20.6.0
How long will it take to get a fix for this?

Best regards,
Rainer

CommandBuilder Quoting

Posted: Wed 08 Feb 2006 22:58
by GuestReply
Hi,
According to the docs, try setting the QuotePrefix and QuoteSuffix properties of the command builder. If you don't mind everything being quoted also set the Quoted property to true.
If this fails, that could be a bug.

Baker

Posted: Thu 09 Feb 2006 15:02
by Guest
Thank you. With this property set to true it works fine.

Rainer