This HISTORY file contains information related to bug fixes, revisions and changes made to Jetpack from Chisel Software. A reference to Jetpack includes all the individual controls contained in Jetpack. DATE VERSION CONTROL CHANGE DETAIL -------------------------------------------------- 2/11/99 x.0.x98 Jetpack Initial public release -------------------------------------------------- 3/19/99 x.0.x99 Queryer .Fixed sql parsing when a field contains a , within ()s eg. SELECT *, Format(Sum(pmtdue),"Currency") as Amount FROM customers 3/19/99 x.0.x99 Design .Fixed bug when saving a table in a database that has not been previously opened by Queryer 3/21/99 x.0.x99 Export .Fixed "Item not found" error when exporting an SQL statement to a jet database table .Added 4 new properties to bypass open dialog 3/23/99 x.0.x99 Jetpack .Modified serial number algorithm 3/25/99 x.0.x99 Jetpack .Incremental release -------------------------------------------------- 4/12/99 x.0.x00 Design .Added Insert New Field by pressing the INS button 4/28/99 x.0.x00 Report .Added support for parameter queries when DataMode is cxSQL 4/29/99 x.0.x00 Queryer .Added support for parameter queries 4/29/99 x.0.x00 Queryer .Added capability to query ISAM databases directly 4/30/99 x.0.x00 Jetpack .Incremental release -------------------------------------------------- 5/08/99 x.0.x01 Export .Added error handling for incorrect Database/SQL specification .Fixed bug where SQL calculated fields were not being exported 5/08/99 x.0.x01 Report .Fixed bug where SQL calculated fields were not being printed 5/11/99 x.0.x01 Zoom .Added copy record button. Procedure copies an entire record only prompting for unique values such as record keys and indexes 5/17/99 x.0.x01 Maint .Added Backup/Restore with file splitting capability to allow copying to/from multiple diskettes 5/19/99 x.0.x01 Queryer .Removed owner prefixes from the table names of ODBC databases. This fixes a bug when accessing DB2 and other databases. 5/19/99 x.0.x01 Jetpack .Incremental release -------------------------------------------------- 5/25/99 x.0.x02 Jetpack .Fixed incorrect Help file being loaded during run-time when F1 key pressed 5/27/99 x.0.x02 Export .Improved support for directly accessing ODBC databases 5/27/99 x.0.x02 Queryer .Improved support for directly accessing ODBC databases 5/28/99 x.0.x02 Find .Fixed bug when accessing ODBC db with SQL that references tables as . 5/28/99 x.0.x02 Maint .Fixed function when restoring split files from floppies 6/04/99 x.0.x02 Queryer .Modified the Add table dialog to stay open until Close button is pressed 6/17/99 x.0.x02 all v5 .Fixed dependency file information for the v5.0 standalone controls (these are the cx????5.dep files located in the windows system directory) 6/17/99 x.0.x02 Jetpack .Incremental release -------------------------------------------------- 7/15/99 x.0.x03 Export .Added OpenDialog property to allow quiet export function ie. without requiring the Export dialog window 7/25/99 x.0.x03 Jetpack .Added three new properties: SystemDb, UserName, Password to provide support for multi-user secured databases 7/28/99 x.0.x03 Jetpack .Incremental release -------------------------------------------------- 7/29/99 x.0.x04 dBOrg .Extended support to allow direct operations between ISAM databases (eg Import/Export between FoxPro and Excel or dBase and Text) 7/29/99 x.0.x04 Design .Fixed a bug when trying to access an existing table to modify 7/29/99 x.0.x04 Jetpack .Incremental release -------------------------------------------------- 8/05/99 x.0.x05 Queryer .Removed the 7/31/99 expiry date of one of its components resulting in a load error (oops) 8/05/99 x.0.x05 Jetpack .Incremental release ----------------------------------------------------------------------------------------------- DATE VERSION CONTROL CHANGE DETAIL 9/09/99 6.0.605 Jetpack .Discontinued support for Jetpack v5.0 (VB5) Queryerx .Added a new UserControl version of Queryer to Jetpack Find .Rationalised naming convention for Jetpack controls as follows: - Find (was Findw) is the Dialog version of the find control - Findx (was Find) is the UserControl version of the find control - Queryer (unchanged) is the Dialog version of the queryer control - Queryerx (new) is the Usercontrol version of the queryer control .Introduced new bundle pricing for Find+Findx and Queryer+Queryerx 9/29/99 6.0.606 Maint .Added support for password protected databases 9/29/99 6.0.606 dBOrg .Added support for password protected databases 10/10/99 6.1.606 Jetpack .Major upgrade from DAO 3.51 to DAO 3.6 (ie. MS Access 2000) for all of the controls contained in Jetpack. Requires Visual Studio 6.0 Service Pack 3 -------------------------------------------------------------------------------- 11/13/99 6.1.607 Queryer/x .Added support for multiple-fields join between tables 11/13/99 6.1.607 Export .Fixed a 'Item not found' error when using a table name (eg Publishers) as the Export SQL string 11/14/99 6.1.607 Jetpack .Incremental release -------------------------------------------------------------------------------- 11/23/99 6.1.608 dBMaint .Added a number of properties to support 'window-less' operation not requiring user intervention. Namely, BackupMode, CollatingOrder, Encrypted, JetVersion, ShowDialog, and SplitSize .Added/fixed support for Access2000 Compact/Repair/Convert operations 11/28/99 6.1.608 Queryer/x .Fixed problem with multiple-fields join between tables .Fixed problem with mixed LEFT and RIGHT JOIN queries .Added support for self-join tables (table aliases) to query .Added support for storing the query design layout. Passed as a Layout property of the Queryer control. .Enhanced the SQLChange event to include SQL and Error parameters 12/02/99 6.1.608 Jetpack .Incremental release -------------------------------------------------------------------------------- 12/11/99 6.1.609 Export .Removed support for binding to a DataControl due to difficulties with DAO 3.6 and future ADO development. .Added property to control whether to show the Export Text dialog. .Removed properties: DataMode, DataControl. .Added property: TextDialog. 12/12/99 6.1.609 Jetpack .Incremental release -------------------------------------------------------------------------------- 12/13/99 6.1.610 Queryer/x .Fixed problem with table aliases contain a space character. .Fixed behaviour of TableAdd dialog - close after adding a table. 12/14/99 6.1.610 Jetpack .Incremental release -------------------------------------------------------------------------------- 1/18/00 6.1.611 Find/x .Added support for searching on Memo fields. 1/19/00 6.1.611 various .Fixed support for accessing user-level secured databases - Export - Import - Queryer/x - Report - Zoom 1/19/00 6.1.611 Jetpack .Incremental release -------------------------------------------------------------------------------- 3/01/00 6.1.612 Report .Fixed problem when reporting more than 32000 records 5/22/00 6.1.612 dBOrg .Added "Show All" files option in Open Database dialog 5/26/00 6.1.612 all .Modified user-interface colors to conform with system colors as defined in Control Panel (Display->Appearance) .Certified to run under Windows 2000 5/28/00 6.1.612 Jetpack .Incremental release - New product bundling and prices -------------------------------------------------------------------------------- 6/9/00 6.1.613 Maint .Fixed bug in SplitCopy backup mode 6/9/00 6.1.613 Jetpack .Incremental release -------------------------------------------------------------------------------- 7/1/00 6.1.614 Zoom .Added Zoom window & Splitter bar for editing memo and OLE fields 7/1/00 Queryer/x .Added TableList property to restrict access to Tables/Queries when viewing Add Table dialog .Added Reserved-Word list for SQL syntax parsing .Released OLEDB version of Queryer & Queryerx (v6.2.614) 7/3/00 6.1.614 Jetpack .Incremental release -------------------------------------------------------------------------------- 7/27/00 6.2.615 Queryer/x .Added Delimited property to force enclosing table & field names with square brackets [] Find/Findx.Released OLEDB version of Find & Findx (v6.2.615) 7/27/00 6.1.615 Jetpack .Incremental release -------------------------------------------------------------------------------- 8/28/00 6.2.616 Queryer/x .Added option to add 'owner' prefix to tables and views when adding tables to query (Oracle and SQLServer friendly) 8/28/00 6.1.616 Jetpack .Incremental release -------------------------------------------------------------------------------- 8/30/00 6.x.617 all .Removed Registration details from About window for all controls to make them Reseller friendly 8/30/00 6.1.617 Jetpack .Incremental release -------------------------------------------------------------------------------- 9/8/00 6.2.618 Queryer/x .Improved support for Oracle 'owner' prefix .Attached (linked) ODBC tables now show in AddTable window .Added support for "Full" outer joins (SQL Server) 9/8/00 6.1.618 Jetpack .Incremental release -------------------------------------------------------------------------------- 10/12/00 6.2.619 Queryer/x .Added support for ADO parameter queries .Added .SQLSyntax property - Queryer now supports "native" SQL syntax for Jet, SQL Server and Oracle datasources Jetpack .Renamed Jetpro61.exe to Jetpro62.exe to reflect content 10/12/00 6.2.619 Jetpack .Incremental release -------------------------------------------------------------------------------- 10/26/00 6.2.620 Export .Released OLEDB version of Export (v6.2.620) -------------------------------------------------------------------------------- 02/11/01 6.2.621 Export .Added RecordsWritten property Queryer/x .Added support for SQL Server tables with IDENTITY columns Jetpack .New Jetpack6.ocx released (Multiple control containing all previous 9 Jetpack controls plus Queryerx and Findx). This replaces the jp*6.ocx controls. Also new pricing. 02/11/01 6.2.621 Jetpack .Incremental release -------------------------------------------------------------------------------- 02/24/01 6.2.622 Queryer/x .Fixed bug with TableList property and ShowOwner checkbox .Fixed persistent open database connection after Queryerx unloaded 02/24/01 6.2.622 Jetpack .Incremental release -------------------------------------------------------------------------------- 03/06/01 6.2.623 Zoom .Added MoveLast; FindCriteria; FindDirection properties 04/06/01 6.2.623 Find/x .Fixed bug to allow multiple Find dialogs to be loaded simultaneously 05/24/01 6.2.624 Queryer/x .Added UserID/Password checking to OLEDB connection 06/17/01 6.2.624 Maint .Added three new properties: SystemDb, UserName, Password to provide support for multi-user secured databases. .Added Error event to Show method 07/20/01 6.2.624 Queryer/x .Added support for stored table relationship when adding tables Queryerx .Fixed HelpButton property to set Help menu option visibility .Added Action property to invoke control's menu options with code 07/25/01 6.2.624 Zoom .Fixed a number of bugs with scrolling and positioning 07/25/01 6.2.624 Jetpack .Incremental release -------------------------------------------------------------------------------- 08/05/01 6.2.625 Zoom .Added support for displaying up to 255 fields 10/04/01 6.2.625 Queryer .Added Close button to interface 12/13/01 6.2.626 Queryer/x .Fixed bug - losing join type when sql has spaces missing around "ON" clause as in "ON(" 01/13/02 6.2.626 Maint .Added Tidy property to delete any temporary files created during its operation 04/26/02 6.2.626 Queryer/x .Added Union queries to AddTable dialog 05/14/02 6.2.626 Find .Added vbModal option to .Show method 05/14/02 6.2.626 Report .Added vbModal option to .Show method 05/14/02 6.2.626 Jetpack .Incremental release -------------------------------------------------------------------------------- 05/19/02 6.2.627 Queryerx .Added CloseSQL method - clears interface and closes db connections 07/01/02 6.2.627 Queryer .Added SQLChecker property - sets initial state of SQL syntax checker 07/01/02 6.2.627 Queryer .Added support for unnamed expressions ie not requiring the AS clause 07/01/02 6.2.627 Queryer .Added support for action query types ie UNION, DELETE, UPDATE, APPEND ... 10/06/02 6.2.628 Find/x .Added ValueListMax property 03/01/03 6.2.628 Queryer/x .Added *Like* to Selection criteria FieldList .Added DragDrop Table field list to Selection Criteria FieldList 04/22/03 6.2.628 Queryerx .Fixed bug when opening property page 04/23/03 6.2.628 Import .Improved text file import performance 05/13/03 6.2.629 Queryer .Improved screen painting when loading and unloading Copyright (c) 1994-2003 Chisel Software. All Rights Reserved.