Unexpected line wrapping

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Unexpected line wrapping

Postby snkscore » Thu Jan 27, 2011 5:26 pm

When I use Layout SQL on a Create Table statement, all of the varchar columns have their "NULL" wrapped onto the next line.

For example this line:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Becomes this:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,

The NULL is indented 26 spaces from where [EventType] is located.

The original line is 76 characters including all spaces. Even thought my "Line Wrap" value in SQL Refactor was set to 78, I tried changing it to 120 and then eventually I turned it off all together, but the NULLs continue to wrap.

Any idea?
snkscore
 
Posts: 5
Joined: Mon Feb 25, 2008 4:48 pm

Postby james.billings » Mon Jan 31, 2011 2:12 pm

Thanks for your post.

If you haven't already, can you check to see if the problem persists if you use the latest cumulative patch? You'll find it here

SQL Refactor has now been replaced with SQL Prompt 5 in case you didn't know - if your serial number has a valid support & upgrades add-on then you can use Prompt 5 for free.
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests