Devart Forums

Comments are being removed from my SQL code. This seems to be caused by adding the comment in the 'Text' tab, then making a change in the 'Query Builder' tab.

For instance, If I have the following code:

SELECT
Users.id,
Users.user_name,
User_Role.Role_id
FROM Users
LEFT OUTER JOIN User_Role
ON Users.id = User_Role.User_id

Lets say I add /* Comment */ in the 'Text' tab, resulting in

SELECT
/*comment*/
Users.id,
Users.user_name,
User_Role.Role_id
FROM Users
LEFT OUTER JOIN User_Role
ON Users.id = User_Role.User_id

The code executes fine, saves fine, and the comment is there if I close and re-open the .sql file without making any changes in the 'Query Builder' tab.

But-if I go into the 'Query Builder' tab, and for instance change the left join to a inner join, the comment disappears when I switch back to the 'Text' tab.

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

Has this issue been fixed in standard edition 3.3.30? Seems to still occur.

This issue is still to be fixed.

Is this issue fixed? It still seems to be a problem in v 5.7.31 for SQL Server. Any view on the timing of fixing this or a workaround - its a real pain.

This forum topic was related to dbForge Studio for MySQL.

In case you are referring to another our product dbForge Studio for SQL Server, please create a new topic at dbForge for SQL Server forum viewforum.php?f=33

Alternatively, you can contact support at supportATdevartDOTcom.

I also had this problem,uno online and the error is still not fixed tunnel rush

Kindly be informed that it's not fixed yet, but we have successfully reproduced it and we are going to fix it in one of the next versions.