SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Vertical colum formatting for Insert

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Vertical colum formatting for Insert
Author Message
RobCrockett



Joined: 15 Aug 2008
Posts: 10
Country: United States

Post Vertical colum formatting for Insert Reply with quote
Hi
I'm using SQL management studio with the SQL set to SQL Server 2000.

When I set the format for an INSERT as follows:
Code:

INSERT ...
(
   ...,
   ...
)
VALUES
(
   ...,
   ...
)

I get the following format when I highlight the code and use CTl-F11:
Code:

INSERT INTO Activity
(
   ID,
   ShopID,
   CustID,
   Comments,
   MileageInterval,
   CouponTitle1
)
VALUES
(1, 2, 3, 'duh', 4, 'sss' )


Why won't the VALUES part format vertically?

Rob
Mon Aug 18, 2008 5:30 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Have you modified wrong format style? Perhaps modified PL/SQL Style 1, but CTRL+F11 used T-SQL Default Style, or something like that?
Mon Aug 18, 2008 6:32 pm View user's profile Send private message
RobCrockett



Joined: 15 Aug 2008
Posts: 10
Country: United States

Post Nope Reply with quote
I am using T-SQL predefined 1. As a test, I removed the vertical formatting from the INSERT section checked the results (It worked) and then restored it (It came back as vertical).
Mon Aug 18, 2008 7:04 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Quote:
It came back as vertical

I'm sorry, I didn't get it. Did you mean that it started working ok after the change?
Tue Aug 19, 2008 12:01 am View user's profile Send private message
RobCrockett



Joined: 15 Aug 2008
Posts: 10
Country: United States

Post Reply with quote
The insert part came back to vertical. The values part stays horizontal.

Code:

INSERT INTO Activity
(
   ID,
   ShopID,
   CustID,
   Comments,
   MileageInterval,
   CouponTitle1
)
VALUES
(1, 2, 3, 'duh', 4, 'sss' )

Wed Aug 20, 2008 10:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
On the formatting style level set the "Text Length for in-line Brackets" option to 0. Hope this helps.
Wed Aug 20, 2008 10:30 am View user's profile Send private message
RobCrockett



Joined: 15 Aug 2008
Posts: 10
Country: United States

Post That did it Reply with quote
Thanks!
Wed Aug 20, 2008 10:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.