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

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

Postby 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.
jswhal
 
Posts: 6
Joined: Fri 28 Dec 2007 18:11

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for MySQL