Project Build Errors

steveba14 · Post by **steveba14** » Tue 03 Jan 2012 12:05

Good Morning,

I am currently getting project build errors in a sproc that uses the ON DUPLICATE KEY UPDATE syntax.

The intelisense is refusing to acknowledge an aliased table in the preceding select statement and is therevfore refusing to build.

I have checked and the sproc runs fine.

Any ideas ? Is this a known issue?

Cheers

Steve

.jp · Post by **.jp** » Tue 03 Jan 2012 12:55

Could you please tell us what version of MySQL Server and dbForge Studio you are using.

steveba14 · Post by **steveba14** » Tue 03 Jan 2012 13:00

Sorry,
dbForge version 5.0.60
mySql 5.5.19

vu · Post by vu » Tue 03 Jan 2012 15:13

Please open the project properties (select Properties from the popup menu of your project). Go to the Database tab and make sure that Server version corresponds to your MySQL server version 5.0.19. If it does not help you, please send us your procedure. If you do not want to post your code on the forum, you can send it to us via the Contact page
http://www.devart.com/company/contact.html

vu · Post by vu » Tue 03 Jan 2012 15:38

Thanks for the DDL of your procedure. We are investigating the problem now.

vu · Post by vu » Tue 03 Jan 2012 15:58

Could you specify full error message?

alexa · Post by **alexa** » Mon 23 Apr 2012 13:56

We would like to let you know that the new version 5.0.72 of dbForge Studio for MySQL, where the issue is fixed, has been released and is available for downloading: http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.