dbForge Studio does not format stored procedure call with stacked parameters well

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
hobiedave
Posts: 16
Joined: Thu 01 Nov 2012 13:39

dbForge Studio does not format stored procedure call with stacked parameters well

Post by hobiedave » Mon 17 Feb 2014 15:09

Surprisingly, when you auto-complete a stored procedure call it nicely formats the parameters but when you apply the formatter to the same call, it shifts all the stacked parameters to the left as shown below:

As inserted:
EXECUTE @RC = dbo.spStmWizard @flow_type
,@meas_mask
,@initiate_time
,@interval_length
,@flow_units

As formatted:
EXECUTE @RC = dbo.spStmWizard @flow_type
, @meas_mask
, @initiate_time
, @interval_length
, @flow_units

I don't see an option to change this. Will Studio be getting the updated formatting engine of Complete?

alexa

Re: dbForge Studio does not format stored procedure call with stacked parameters well

Post by alexa » Mon 17 Feb 2014 17:15

Could you please provide us the screenshots displaying the actual and expected result as formatting seems to be displayed not correctly on the forum post?

Also, please provide us the active .xml profile that can be found as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate 'Text Editor -> Formatting -> Profiles' branch.
3. Right-click the active profile and select 'Show in Folder' from the popup menu.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you via e-mail.
Will Studio be getting the updated formatting engine of Complete?
A new version of dbForge Studio for SQL Server that we are currently working on, will have the formatting feature identical to the one present in dbForge SQL Complete, v4.5.

Post Reply