Incorrect generation of update statment using the query designer in VS 2008

jswhal · Post by **jswhal** » Mon 21 Apr 2008 18:41

When I use myDirect with Visual Studio 2005, the query designer creates a statement that looks like this

UpdateCommand="UPDATE `TASK_BATCHES` SET `PRIORITY` = ? WHERE `ID` = ?">

If I use Visual Studio 2008, it creates

UpdateCommand="UPDATE TASK_BATCHES SET PRIORITY = :PARAM1 WHERE (ID = :PARAM2)">

the second form does not work. I'm using version 4.30.24.

Alexey.mdr · Post by **Alexey.mdr** » Tue 22 Apr 2008 10:24

Could you please specify which query designer do you use?
Please send me (alexeyman*crlab*com) a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.