Red Gate forums :: View topic - Change nbsp behaviour?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

Change nbsp behaviour?

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mike.hebert



Joined: 01 Aug 2007
Posts: 4
Location: Edmonton, Alberta, Canada

PostPosted: Thu Aug 02, 2007 11:18 pm    Post subject: Change nbsp behaviour? Reply with quote

Is there any way to configure SQL Doc to emit normal spaces instead of non-breaking spaces for all MS_Description fields? If so, it would also be handy to be able to default the vertical alignment of the table cells to "top".

We have long descriptions for some of our tables, fields, check constraints, etc., and I'm finding that the generated docs are almost unreadable because of the non-breaking spaces.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Wed Aug 08, 2007 6:23 pm    Post subject: Reply with quote

Hi Mike

It is possible to modify the document generated.

You can modfiy the Documentation Style as follows:

By default, SQL Doc creates your database documentation using HTML with frames. SQL Doc generates database documentation with frames much more quickly and the file sizes are smaller. You are recommended to use this setting if you are documenting large databases.

To create database documentation without frames, change this setting to HTML without frames.

To create database documentation in compiled HTML Help format (.chm), change this setting to Microsoft HTML Help (.CHM). Note that you must have Microsoft® HTML Help Workshop installed on your computer to create a .chm file; a free download is available from the Microsoft Download Centre.

Also You can modify the style sheets that SQL Doc uses to generate the database documentation, if required. In addition, when the documentation has been generated, SQL Doc provides all the source files so that you can edit them if required.

Modifying style sheets
SQL Doc uses Cascading Style Sheets (CSS) to determine the appearance of the database documentation. You can edit the master style sheet using a CSS editor, for example to change fonts, font sizes, font colors, text alignment, or table properties.

The SQL Doc master style sheet (master.css) determines the appearance of the Preview pane and the generated documentation. The style sheet is located in the subfolder Style1/Style where you installed SQL Doc. You are recommended to make a copy of the master style sheet before you edit it.

Note that you can edit the style sheet to hide the creation SQL. To do this, under the .sqlScript class, add the declaration display: none;

Modifying Microsoft HTML Help documentation
When SQL Doc generates database documentation as Microsoft HTML Help, all the project files associated with the .chm file are also provided. You can edit these files and recompile the help using Microsoft HTML Help Workshop if required.

For example, the default project language is English; if your database documentation contains characters from a different Unicode character set, you may want to change the language setting in the project (.hpp) file and then recompile the help so that the characters are displayed correctly.

To open Windows® Explorer at the location of the saved project documents, open the project in SQL Doc, and click Alt+E.


I hope the above helps.

Eddie Davis
Red gate Software Ltd
Technical Support Engineer
E-Mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
BobGood



Joined: 25 Mar 2008
Posts: 8

PostPosted: Tue Mar 25, 2008 6:15 pm    Post subject: I also have problem with SQL Doc putting nbsp in output Reply with quote

How can I control the following behavior?

SQL Doc outputs the MS_Description extended property including nbsp in place of normal spaces.

This causes a very long horizontal scroll situation, including making the html output unprintable on a single page.

and example of the html source created is:

The name of the container of the report. Typically the name of the Access database, SQL database, SQL Report server, DTS container, Excel workbook, etc. where the report definition or code resides

The preferred output would be a wrappable and readable:

The name of the container of the report. Typically the name of the Access database, SQL database, SQL Report server, DTS container, Excel workbook, etc. where the report definition or code resides

Regards,
Bob Good
_________________
Bob Good
Back to top
View user's profile Send private message
ivarley



Joined: 28 Apr 2008
Posts: 2

PostPosted: Mon Apr 28, 2008 11:34 pm    Post subject: Re: I also have problem with SQL Doc putting nbsp in output Reply with quote

I'm having the same problem. The documentation is basically unreadable because of all the nbsps ... you have to scroll way out to the right and back. Can this be changed?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon May 05, 2008 1:23 am    Post subject: Reply with quote

Hi all,

This may not be the best solution, but I have a workaround for Internet Explorer that may be useful. By changing the SQL Doc stylesheet, you can get the database description text to fit in the page, however wrapping doesn't happen at the spaces, because of course the non-breking space (&nbsp) isn't supposed to allow that. So some words may be split in the middle between two lines. This may be better than letting the text run off of the page, I'll let you decide! Smile

Open the master.css (stylesheet) file at %programfiles\red gate\sql doc 1\style1\style with notepad.exe, and change the .breadcrumbs section to add word-wrap: break-word;
Code:
.breadcrumbs
{
   
   font-size: 80%;
   font-weight: normal;    
   margin-bottom: 10px;
   padding: 4px;    
   word-wrap: break-word;
}
Back to top
View user's profile Send private message
NYBlue



Joined: 29 Feb 2008
Posts: 8

PostPosted: Thu May 08, 2008 6:49 pm    Post subject: Any fix for the Columns that would do the same behavior? Reply with quote

The fix above helped me.
Back to top
View user's profile Send private message
NYBlue



Joined: 29 Feb 2008
Posts: 8

PostPosted: Thu May 08, 2008 8:32 pm    Post subject: Any fix for the Columns that would do the same behavior? Reply with quote

Any fix for the Columns that would do the same behavior?
Back to top
View user's profile Send private message
NYBlue



Joined: 29 Feb 2008
Posts: 8

PostPosted: Wed Jun 04, 2008 9:20 pm    Post subject: Does anyone know if this is fixed in Internet Explorer 8? Reply with quote

Does anyone know if this is fixed in Internet Explorer 8? Rolling Eyes
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Thu Jun 05, 2008 5:16 pm    Post subject: Reply with quote

Hi,

It should be fixed in the next version of SQL Doc. The problem is that IE takes the non-breaking space quite literally and doesn't wrap any text connected by these   entities. The next version of SQL Doc will use plain old spaces instead of nbsp so that the text will wrap.
Back to top
View user's profile Send private message
NYBlue



Joined: 29 Feb 2008
Posts: 8

PostPosted: Mon Aug 18, 2008 2:54 pm    Post subject: This Fix Worked For Me ...Thanks! Reply with quote

This Fix Worked For Me ...Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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