Archive for October, 2005

A very productive weekend

October 31st, 2005

What a good sensation when you get “in the zone” not just a few hours but a whole weekend. This sensation is especially good if you have been in low productivity mode for several days or even weeks. This time the trigger to enter in “flow mode” has been installing the final version of SQL [...]

Adding a WordML XSLT template to dbdesc (IV)

October 23rd, 2005

Adding table details
Table details section contains the list of fields in a database table. It also contains the properties of each field. The best way to represent all this info is using a table.
As I mentioned in my last post, the best way to deal with tables is saving a Word document with just a [...]

Adding a WordML XSLT template to dbdesc (III)

October 17th, 2005

Adding formatting styles
You can add some formatting style to every run of text <w:r></w:r>. Indeed, if you want to apply different styles to different words, those words must be placed separately inside their own <w:r> tags. Take a look at this post by Brian Jones to learn about WordML formatting.
In the following code, I’ve just [...]

Adding a WordML XSLT template to dbdesc (II)

October 10th, 2005

In my last post I decided to add a Word 2003 (WordML) template for dbdesc. The goal for this post is to get a first version of that template that builds a list of tables of a database.
The best way to start building the template is to write the simplest working WordML document, so this [...]

Adding a WordML XSLT template to dbdesc

October 6th, 2005

Currently dbdesc allows you to view database documentation in Word by using the Rich Text Format (RTF) template. It works nice. However, if you want to customize this template you are going to face a tough task because of the way RTF handles blanks. I’ve done it and it’s hard.
By the way, I think it’s [...]

dbdesc 1.1 released!

October 3rd, 2005

I’ve just uploaded the new version of dbdesc a few minutes ago. The main features added to this version are support to query password protected Access databases and support to extract User Defined Functions (UDF) related info from SQL Server and Firebird databases.
I’ve made little changes to the XML schema too. Now XML elements are [...]