Page 1 of 1

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

Posted: Mon 21 Apr 2008 18:41
by jswhal
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.

Posted: Tue 22 Apr 2008 10:24
by Alexey.mdr
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.