Reserved Words for Columns are not Escaped

Reserved Words for Columns are not Escaped

Postby adun9002 » Sun 14 Mar 2010 14:58

I have a TextResource table for localization. I chose the simplest names possible for my Columns. (RegionCode, Key, Value) The Key column name is not escaped such as `Key` when passed to MySql therefore the SQL is invalid. I found that I can modify the Property Source Name in the Entity Developer which is very nice but I hate the idea that I would have to remember this should I want to Blow out and repopulate the Schema. Can we make the Sql Builder automatically escape all entity names using the `ObjectName` syntax?

Is anyone else having this issue?
adun9002
 
Posts: 1
Joined: Sun 14 Mar 2010 14:52

Postby AndreyR » Tue 16 Mar 2010 14:06

Thank you for the report, we have reproduced the problem.
I will let you know about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Thu 04 Nov 2010 09:24

We have fixed the error. The fix will be included in the nearest build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL