v4 formats this differently than v3

Oliwa

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

INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES  ( 0, -- PortfolioID - int
          0  -- ServicingTypeID - int
          )

Where it used to do this...

INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES     ( 0, /* PortfolioID - int */, 0 /* ServicingTypeID - int */)

I am using standard edition.

Anu D

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?

Oliwa

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

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.

Anu D

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.