Devart Forums

Posted: **Wed 17 Aug 2016 10:21**

dbForge removes comments for the procedure parameters when I edit anything inside Parameter panel.

Let’s say I have

...

Code: Select all

PROCEDURE host1355175_te.sp_fc_again(
IN p_user_id int /*comment for the procedure parameter is here*/, IN p_pair_id int, IN p_deb int, OUT o_res int)
  COMMENT 'Comment for the procedure is here'
BEGIN

...

“/*comment for the procedure parameter is here*/” will be removed if I, for instance, edit Comment via UI in Options panel or change parameter’s order.

Posted: **Wed 17 Aug 2016 11:24**

This happens because the MySQL server doesn't store comments. So, it's not supported by MySQL itself.

Posted: **Wed 17 Aug 2016 21:03**

MySQL server perfectly stores comments for stored procedures. It has such a problems for views only...
And my procedures had comments stored in mysql db before they've been touched by dbForge.

Posted: **Thu 18 Aug 2016 12:43**

Sorry for the confusion. That's right. This is caused by dbForge.

We will try fixing this in one of the next product versions.

Posted: **Wed 21 Jun 2017 15:21**

We are planning to handle this as a feature request. Please vote for https://devart.uservoice.com/forums/772 ... -procedure

Devart Forums

dbForge removes comments for the procedure parameters

dbForge removes comments for the procedure parameters

Re: dbForge removes comments for the procedure parameters

Re: dbForge removes comments for the procedure parameters

Re: dbForge removes comments for the procedure parameters

Re: dbForge removes comments for the procedure parameters