v4 formats this differently than v3

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

v4 formats this differently than v3

Postby Oliwa » Fri Aug 06, 2010 1:47 pm

I recently upgraded to v4.0.3 from v3.9 and when SQL Prompt auto generates my insert statement it now does this...

Code: Select all
INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES  ( 0, -- PortfolioID - int
          0  -- ServicingTypeID - int
          )


Where it used to do this...

Code: Select all
INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES     ( 0, /* PortfolioID - int */, 0 /* ServicingTypeID - int */)


I am using standard edition.
Oliwa
 
Posts: 28
Joined: Thu Jan 11, 2007 6:15 pm

Postby Anu Deshpande » Mon Aug 09, 2010 11:11 am

Many thanks for your post.

Yes it has been changed since version 3.

Any specific reason you would like the values option on single line?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Oliwa » Mon Aug 09, 2010 1:40 pm

I actually don't, I want the format of the insert to be like this...

Code: Select all
INSERT      dbo.PortfolioServicingType
                 (
                     PortfolioID
                     , ServicingTypeID
                 )
VALUES      (
                     0 -- PortfolioID
                     , 0  -- ServicingTypeID
                 )


But since I don't think the Standard version will do that putting it all on one line makes it easier for me to format how I want it.
Oliwa
 
Posts: 28
Joined: Thu Jan 11, 2007 6:15 pm

Postby Anu Deshpande » Tue Aug 10, 2010 10:25 am

Oh!

It is configurable in SQL Prompt professional edition.

I am sorry about that!

I have added this as a feature request to format it as per your request.

i.e. values on one line. Tracking id for the feature request is SP-3334.

I will update you as soon as it is incorporated.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest