Devart Forums

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?

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.