Devart Forums

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

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

Sorry,
dbForge version 5.0.60
mySql 5.5.19

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

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

Could you specify full error message?

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.