CommandBuilder does not generate double quotes around case sensitive columns

CommandBuilder does not generate double quotes around case sensitive columns

Postby 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
Guest
 

CommandBuilder Quoting

Postby 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
GuestReply
 

Postby Guest » Thu 09 Feb 2006 15:02

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

Rainer
Guest
 


Return to dotConnect for Oracle