ASPcodePrint – Release History

SQL2000Print– Version History
© 1990-2007 STARPRINT LIMITED

Version

Description

1.10.86

3rd December 2007

Enhancements

Fixed the following error:

Error Number : -2147319779

Description : Automation Error Library not registered

Application : SQL2000Print

Version : 1.10.85

Component : frmMain

Member : LoadDatabaseObjects

Stage : Entry Point

1.10.84

21^st July 2007

Enhancements

Windows Vista support added

1.10.83

Fixed Bugs

Printing encrypted Stored Procedures cause the following error:

Error Number : -2147200919

Description : [SQL-DMO]/****** Encrypted object is not transferable, and

script can not be generated. ******/

Application : SQL2000Print

Version : 1.10.82

Component : frmPreview

Member : PrintStoredProcedure

Stage : SELECT * FROM ::fn_listextendedproperty(NULL, 'user','dbo',

'Procedure','Spot_LogShippingInSync',NULL,NULL)

1.10.82

Fixed Bugs

· The printout can be customized to include grid lines for improved readability

The facility is available using Options > General, check Print Grid Lines

· A program error occurs if the database goes offline while processing objects for printing

· The registration code does not stick in rare circumstances

1.10.81

Fixed Bugs

· The application does not connect to SQL server 2000.

1.10.80

Enhancements:

· An option has been provided to enable/disable printing of extended properties for Views

· Provide an option to print a Table of Contents which can be enabled/disabled using Options | General Print Table of Contents

Fixed Bugs

· Header and footer settings are not saved and restored when the application restarts

1.10.78

Enhancements:

· The custom page header and footer strings now support macro and environment variable substitution.

Supported macros are:

1. {Database Name}

2. {Datetime}

3. {Date}

4. {Filename - No Path}

5. {Filename}

6. {Object Name}

7. {Page}

8. {Server Name}

9. {Time}

Environment variable should be enclosed in % characters. For example, %USERNAME%

Examples:

1. Click on Options on the toolbar

2. Click on Header / Footer

3. Enter a string that contains one of the above macros or %environment variable% in the left, centre or right segment for header and or footer as show below:

To Display	Enter
Printed on 29/12/2005	Printer on {Date}
Produced by J.S Nahil	Produced by %USERNAME%
Page 5 Printed 31/12/2005 at 12:45PM	Page {Page} Printed {Date} at {Time}

1.10.77

Improved performance and error handling

Remove dependency on shared DLL AutoErrorTrace.DLL to avoid conflict with other Starprint products

1.10.76

Fix the bug that displayed incorrect caption in the Options dialog box

Fix the bug that caused the preview window not to be displayed in all Options tabs

1.10.75

Fix the bug that caused extended properties to be output as’ ???????’

Enhance View output to included extended column properties

Deals with views, tables and column names that have a single quote (‘) in the name

1.10.74

Show printing options more often as user clicks on nodes

1.10.73

Printing the extended properties of a table or table columns has been made optional.

Click on the ‘Tables’ node in the database explorer treeview and select ‘Print extended Properties’ to select/deselect as appropriate.

Suppress printing of hypothetical keys

1.10.72

Fix error 372/Failure to load control ‘ctxNumericTextBox’ frp spNumericTextBox

Application: SQL2000print
Version: 1.10.70
Component: frmConnect
Member : Connect

1.10.70

Remove 3^rd party OCX to reduce the application size and support dependency

1.10.69

Implemented a new menu option File | Preview SQL in Clipboard to allow the SQL in the clipboard to be previewed in color coded syntax highlighted format.

This is particularly useful when you want to print SQL that is not in a Stored Procedure.

1.10.68

Integrated the latest Print/Preview and export software from ComponentOne to improve print, preview and export output

If a stored procedure prints on more than one page then do not indent the 1st line on 2nd and subsequent pages of output

1.10.67

Fixed the following Bugs:

The heading for the table/view column names should print [K I G N C] however it prints [ I N C ]

Prevent the following error:

Error Number : 91

Description : Object variable or with block variable not set

Application : SQL2000Print

Version : 1.10.66

Component : frmPreview

Member : PrintTable

Stage : Entry Point

1.10.66

Fixed the bug that caused multi-part keys not to be formatted correctly

1.10.65

Performance improvements

Incorporate the latest print/preview ocx

The printed output takes note of printer property settings

Prove an option to include/exclude table keys in the printout

1.10.5

· Clear the following errors:

Error Number : -2147221296

Description : Automation error

Application : SQL2000Print

Version : 1.10.0

Component : frmPreview

Member : PrintView

Stage : Get views collection

Date and time : 2/20/2003 9:30:00 AM

----------------------------------------------------------------

Error Number : -2147221297

Description : [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid column name 'Name'.

Application : SQL2000Print

Version : 1.10.0

Component : frmPreview

Member : PrintTable

Stage : Entry Point

Date and time : 2/19/2003 8:53:05 AM

Clear the bug that caused Watermarks from being printed

1.9.75

Clear the following errors:

Error Number : 35602

Description : Key is not unique in collection

Application : SQL2000Print

Version : 1.9.70

Component : frmMain

Member : LoadDatabaseObjects

Stage : Add Database 'assets_dev' to the tree with key saassets_dev(sa)'

1.9.0

Clear the following errors:

Error Number : 424

Description : Object required

Application : SQL2000PRINT

Version : 1.9.39

Component : frmMain

Member : LoadTreeView

Stage : Load BackupDevices

Error Number : 5

Description : Invalid procedure call or argument

Application : SQL2000Print

Version : 1.9.31

Component : frmPreview

Member : PrintSeparator

Stage : Entry Point

Prints the extended property 'Description' for the columns of tables

Please note that registered users will require a new registration code which can be obtained from STARPRINT Limited by sending them an email to:

upgrades@starprint2000.com

The new registration code will only be provided to users who will supply a proof of purchase of this product.

Cleared a bug that did not print the ending ' of a strings in Stored procedures

Improved behavior with no printer attached

Prevent print dialog from changing printer / paper size

Monochrome printing is handled correctly

Option setting usability has been improved

Unregistered version only supports export to PDF format

Exporting to RTF still does not support full header/footer details, however, now the output contains the page header at the start of each component

Exporting to HTML has been improved to remove blank lines between every line of output.

Cleared a bug: Printer selection was not always remembered

1.8.9

Make sure that the main application window is in the foreground after preview windows closes

Remember the name of the directory to which the output was last exported and use that directory for subsequent exports

Clear the following error

Error Number : 380

Description : Invalid property value

Application : SQL2000Print

Version : 1.8.8

Component : basCommonRoutines

Member : GetPrintParameters

Stage : Entry Point

Date and time : 8/13/2001 2:52:21 PM

1.8.8

Clear the following error when trying to process SQL Server 7 Objects from SQL2000Print

Clear the following error

Error Number : 13

Description : Type mismatch

Application : SQL2000Print

Version : 1.8.7

Component : frmMain

Member : LoadObject

Stage : Set current database object to 'GetFaxon'

Date and time : 7/20/01 3:57:07 PM