CommandBuilder does not generate double quotes around case sensitive columns

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Guest

CommandBuilder does not generate double quotes around case sensitive columns

Post by Guest » Wed 08 Feb 2006 16:21

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

GuestReply

CommandBuilder Quoting

Post by GuestReply » Wed 08 Feb 2006 22:58

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

Guest

Post by Guest » Thu 09 Feb 2006 15:02

Thank you. With this property set to true it works fine.

Rainer

Post Reply