February 18th, 2012· Updated some third party components.
January 16th, 2012· Fixed an issue in restructuring tables having default values.
January 16th, 2012· Fixed issue with F3 shortcut key in search/replace dialog
January 16th, 2012· Fixed case sensitivity issue in search/replace dialog
January 16th, 2012· Modified error reporting options to include only basic debug information
January 16th, 2012· Fixed bug causing the locking of the database file after an unsuccessful attempt to open an encrypted database
January 16th, 2012· Fixed text clipping issues in data transfer wizard when using large fonts.
· Fixed bug in grid filter on GUID fields.
· SQLite library 3.7.9 included.
January 16th, 2012· Minor user experience improvements.
· License upgrade tool no longer included.
January 16th, 2012· Fixed a bug in retrieving the SQLite error message
January 16th, 2012· Fixed bug in exporting GUID values to CSV
January 16th, 2012· Checking for updates now allows downloading and installing new version from within the program
January 16th, 2012· Fixed incorrect ordering on Database tab
October 10th, 2011· Fixed bug on extensions tab - functions and collations displayed for the wrong extension.
September 24th, 2011· DOCID is now preserved when restructuring virtual table.
August 8th, 2011· Minor internal fixes.
July 15th, 2011· Updated help file.
May 21st, 2011· SQLite library 3.7.6.3 is now included.
May 21st, 2011· Fixed bug causing incorrect order of fields in an index.
May 21st, 2011· Fixed startup error message when using external library.
· Fixed "table not found" error when creating an index on a new table.
May 9th, 2011· The 'move up' and 'move down' buttons now work with multiple selected records on the field designer.
May 9th, 2011· Fixed bug in index editor.
May 9th, 2011· Improved JPEG image format detection.
May 9th, 2011· The record counts are now calculated using separate connections to the database.
April 22nd, 2011· The record count feature is now optional.
April 21st, 2011· The record count feature is now disabled to prevent performance issues on large databases. It will be made optional in the next version.
April 18th, 2011· SQLite library 3.7.6.2 is now included.
April 18th, 2011· Fixed field not found error when primary key field contains blank characters.
April 16th, 2011· Record count is now always displayed for all tables and views.
· SQLite library 3.7.6.1 is now included.
April 16th, 2011· Fixed AV after opening and canceling the Options window.
April 16th, 2011· Fixed error in refreshing schema after deleting an object.
April 16th, 2011· Fixed error in sorting objects by dependencies when exporting data.
· Fixed error in generating SQL for tables having foreign keys.
April 16th, 2011· SQLite library 3.7.6 is now included.
April 16th, 2011· Fixed program startup error when using auto-extensions.
April 16th, 2011· Added support for the ICU extension.
April 16th, 2011· Fixed bug in refreshing data when being displayed in text mode.
April 16th, 2011· Fixed bug in importing null values from CSV files.
April 16th, 2011· Added database online backup option.
March 28th, 2011· Added database DDL compare tool.
March 21st, 2011· Added options "Auto cell height" and "Show cell hints" to main menu.
March 21st, 2011· Added support for RTREE virtual tables.
March 18th, 2011· Added support for virtual tables including FTS3 and FTS4.
· Added progress bar, cancel button and improved performance when generating random data.
March 18th, 2011· Added option "Execute SQL (current statement)".
March 18th, 2011· Fixed a bug in refreshing schema.
March 18th, 2011· Fixed a bug in the internal parser.
March 18th, 2011· Improved tabbed navigation on the record editor.
March 18th, 2011· Modified internal handling of blob fields for accurate display in the Hex editor regardless of the storage class.
March 18th, 2011· Fixed bug introduced in previous version preventing the usage of external SQLite libraries.
March 18th, 2011· Added support for changing the field sort order in the index editor.
February 7th, 2011· Fixed datetime display error occurring for date values above year 2100.
February 2nd, 2011· Fixed a registry error when reading file associations
January 21st, 2011· Fixed error in copy/paste records on systems with decimal separator different than ".".
January 19th, 2011· Fixed incorrect application title in Professional Edition.
January 8th, 2011· Upgraded external SQLite library to 3.7.4.
January 7th, 2011· Minor UI fixes.
January 5th, 2011· Added associated extensions to the list of file extensions in the open database dialogs.
January 5th, 2011· Performance improvements for datasets with a large number of columns.
December 17th, 2010· SQLite library version 3.7.4 is now included.
· Added option to set a default encryption key.
· Minor internal fixes.
November 16th, 2010· Improved image format detection for images displayed in the grid.
November 15th, 2010· Grid selection is now cleared after sorting by a column.
November 15th, 2010· Fixed cell auto height not using the current setting on a new SQL tab.
November 12th, 2010· Minor corrections to the Pascal script engine.
November 11th, 2010· Added "Close other SQL tabs" menu item.
· Updated sample scripts to work with version 3.
· Fixed an error in Lua script output.
· Fixed a database locking error.
November 11th, 2010· Added database repair function.
· Added pragmas automatic_index and wal_autocheckpoint.
· Fixed error updating data after modifying in Hex editor.
November 11th, 2010· Fixed error in local time calculation when using the internal SQLite library.
October 10th, 2010· Added rowid to the parent key drop-down list in the foreign key editor.
October 9th, 2010· SQLite library version 3.7.3 included.
October 8th, 2010· Fixed bug in import from a text file with encoding set to "Default ANSI code page" on multi byte character sets.
October 7th, 2010· Fixed error in refreshing non-integer primary key for tables having unique constraints".
October 6th, 2010· Fixed bug in import from a text file with encoding set to "Default ANSI code page".
October 2nd, 2010· Fixed error in local time calculation when using the internal SQLite library.
October 1st, 2010· Fixed SQLite library not restored at application startup.
September 29th, 2010· Fixed bug in restoring SQL history at application startup.
September 27th, 2010· Implemented some schema refresh optimizations.
September 27th, 2010· Fixed error in local time calculation when using internal lSQLite library.
September 27th, 2010· Added tab width option.
· Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.
September 14th, 2010· Added option to open multiple SQL tabs.
September 10th, 2010· Fixed incorrect restoring of SQL queries containing double quotes at program startup.
· Internal SQLite library now supports encryption (Professional Edition).
September 2nd, 2010· Added word-wrap option for SQL editors.
September 2nd, 2010· Fixed child fields not being renamed when renaming field in tables with multiple foreign keys.
September 1st, 2010· Fixed tab character not expanded in the grid and in the tooltip windows.
September 1st, 2010· Fixed current record number not being displayed except the first SQL tab.
· Fixed conversion error when applying a filter on a field containing null records.
August 25th, 2010· SQLite library 3.7.2 included.
August 23rd, 2010· Fixed navigator buttons not working on the SQL tabs.
August 23rd, 2010· Fixed record number not showing on the SQL grids.
August 23rd, 2010· SQLite library 3.7.1 included.
August 23rd, 2010· SQL Builder now generates queries in a new SQL tab to preserve existing queries.
August 23rd, 2010· Added option to open multiple SQL tabs.
· Added WAL mode to the journal_mode drop-down list on Database tab.
August 20th, 2010· Fixed "cannot focus invisible window" error when attempting to create a new table.
August 7th, 2010· SQLite library 3.7.0.1 included.
August 7th, 2010· Unfortunately the fix in 3.0.36 introduced a bug so the changes have been rolled back.
August 7th, 2010· The progress bar and the cancel button are now working when importing an SQL script.
· Fixed out of memory error when importing very large SQL scripts.
August 7th, 2010· Fixed error when copying a large number of records to clipboard.
August 2nd, 2010· Fixed 'invalid typecast' error when importing GUID fields from ADO data source.
August 2nd, 2010· Modified field editor to allow empty field types.
· Fixed an error when importing CSV file into an existing table.
July 29th, 2010· Added skin library.
· Added printing library.
· Added support for custom delimiters when exporting/importing to/from text files.
· Added option to allow only one instance of the application.
· Grid rows now resize height with the size of the text.
May 27th, 2010· Fixed bug in handling savepoints with duplicate names.
May 18th, 2010· Minor customizations in the appearance of horizontal scroolbar in SQL and scripting editors.
· Fixed horizontal scroll repainting problem in SQL and scripting editors.
May 13th, 2010· Fixed table filter being removed when resizing the window.
May 13th, 2010· Fixed a few toolbar visibility issues
May 12th, 2010· Fixed cell hints not working after optimizations introduced in 2.4.40.
May 12th, 2010· Minor bug fixes.
May 12th, 2010· Implemented some optimizations for handling large text fields in the grid.
May 10th, 2010· Minor UI improvements.
May 10th, 2010· Fixed an internal parser error.
· Fixed AV in the left tree view.
May 10th, 2010· Replaced some of the toolbar icons.
· Fixed grid refresh error when two or more columns are filtered.
· Fixed a parsing error causing incorrect display of foreign key constraints.
May 10th, 2010· Fixed a data refresh issue when creating a new table.
· Fixed resync issue when editing data in the grid.
May 10th, 2010· In the image editor, dbl-click on the image will maximize or restore the window.
· RowID is now added to non-editable SELECT queries, so in most cases they become editable.
· Removed some redundant refresh operations.
· Fixed error when executing Pascal scripts in encrypted databases.
May 10th, 2010· Improved cell hint behavior.
· Fixed a bug in grid editing.
May 10th, 2010· To avoid any confusion, export menu items have been removed from the tree popup menu and from the main menu. Export options apply to the selected grid, so they will only be available in the grid popup menus
May 10th, 2010· When a database is selected, the DDL tab now shows the whole create script for the database.
· In data transfer operations, the objects are now copied in the order of dependencies.
· SQLite library 3.6.23.1 is now included.
May 10th, 2010· The Show/Hide features is now the first tab in Tools/Options.
· Fixed a startup bug when launching the application with an encrypted database in the command line.
· Upgraded some components.
· In Options, renamed fonts to 'Application Font' and 'SQL Editor Font'.
· Some minor UI fixes.
May 10th, 2010· Added option to hide tabs and menu items to prevent bloating the user interface.
· Fixed a parser error in foreign keys.
· Implemented workaround for determining the setting of case_sensitive_like pragma.
· Fixed concatenation operator || not being recognized by SQL Builder.
May 10th, 2010· Added options for code completion.
May 10th, 2010· Added experimental code completion.
November 2nd, 2009· Fixed a minor bug in the foreign key editor.
October 30th, 2009· Added 'Reindex Table' and 'Reindex All Tables' options.
· Added support for auto extensions.
October 27th, 2009· Fixed error in updating records when editing data in the grid if key is a GUID stored as BLOB. .
October 27th, 2009· Fixed error in loading text values stored using BLOB storage class.
October 27th, 2009· Restructuring a table referenced in foreign keys is now allowed if the table does not contain data.
· More updates to the help file.
October 27th, 2009· Fixed bug in data transfer for empty, not null values.
· Minor updates to the help file.
October 27th, 2009· Some restructure operations are now disabled on tables referenced by foreign keys.
· Added label displaying the number of foreign keys referencing the current table.
October 27th, 2009· Foreign keys are now exported to SQL scripts.
· Fixed bug in SQL parser.
October 27th, 2009· Tables are now reordered by dependencies when importing or deleting, for preventing foreign key constraint violations.
October 27th, 2009· This is a beta version with foreign key support.
· SQLite library 3.6.19 is now included.
October 27th, 2009· Updated definition of site license in the license agreement.
October 27th, 2009· A few cosmetic UI fixes. .
October 27th, 2009· Fixed Cut and Paste issues when editing data in the grid.
October 27th, 2009· Fixed SHIFT-INSERT paste shortcut not working as expected when editing data in the grid.
October 27th, 2009· Fixed an issue in the behavior of the horizontal scrollbars in the grids.
October 27th, 2009· Added thumb tracking option for grid scrollbars.
October 27th, 2009· Fixed error in Query Builder preventing the default settings from being applied when creating a new join
October 27th, 2009· Fixed AV that may occur when closing application if any registered database is not connected.
October 27th, 2009· Fixed popup menu shortcut interfering with pasting data in the grid.
October 27th, 2009· Fixed incorrect update of CHAR fields when encoding is set to "Default ANSi code page".
October 15th, 2009· Updated definition of site license in the license agreement.
October 12th, 2009· A few cosmetic UI fixes.
October 12th, 2009· Fixed Cut and Paste issues when editing data in the grid.
October 2nd, 2009· Fixed SHIFT-INSERT paste shortcut not working as expected when editing data in the grid.
October 1st, 2009· Fixed an issue in the behavior of the horizontal scrollbars in the grids.
September 30th, 2009· Added thumb tracking option for grid scrollbars.
September 29th, 2009· Fixed error in Query Builder preventing the default settings from being applied when creating a new join.
September 29th, 2009· Fixed AV that may occur when closing application if any registered database is not connected.
September 28th, 2009· Fixed popup menu shortcut interfering with pasting data in the grid.
September 28th, 2009· Fixed incorrect update of CHAR fields when encoding is set to "Default ANSi code page".
September 23rd, 2009· Added options to set the selected cells to NULL or to a specific value.
· Upgraded some third party components to their latest versions.
September 21st, 2009· A few more internal fixes in the Query Builder.
September 20th, 2009· Fixed a repainting issue on Query Builder.
September 20th, 2009· Fixed access violation that might occur at program shutdown when Query Builder is the active page
September 19th, 2009· Minor usability improvements.
September 17th, 2009· Fixed "index out of range" error when attempting to copy to clipboard more than 256 records at a time.
September 16th, 2009· Updated help file with the latest features.
· Minor user interface changes
September 16th, 2009· Fixed bug that may cause loss of data when restructuring tables with no primary key. Upgrade from versions 2.1.8 and 2.1.9 is highly recommended.
September 16th, 2009· Added support for loaded extensions.
September 14th, 2009· Enabled editing triggers and constraints in Personal Edition.
· Enabled cell select mode. Added option to switch between cell select and row select modes.
· Modified query parameter prompt to accept string parameters not enclosed in quotes.
· Added 'Generate random data' function.
· Improved error handling.
· SQLite library 3.6.18 is now included.
· A few internal bug fixes.
September 11th, 2009· Fixed "Could not convert variant of type (Array Byte) into type (Integer)".
September 10th, 2009· Fixed incorrect update of DATE and TIME fields when the default ANSI code page is selected.
September 9th, 2009· Fixed error preventing the opening of attached databases at startup
September 8th, 2009· Added experimental support for parameters in SQL statements.
· Added support for images imported from Access prefixed with an OLE header.
· Replaced main application icon.
September 5th, 2009· Attached databases were not restored after changing options. This has been fixed.
· ALT-F4 shortcut was not closing the application. This has been fixed.
September 4th, 2009· Enabled multiple selection for Empty Table function.
· Fixed conflict between main menu shortcuts and typing extended ASCII characters using ALT codes.
September 3rd, 2009· Enabled multiple selection on tables and views for drag-drop, copy-paste and delete operations.
· Fixed a few conflicting menu shortcuts.
August 31st, 2009· Added support for attached databases.
· Added support for nested transactions.
· Added ability to copy tables between databases using the clipboard (Professional Edition).
· Added ability to copy tables between databases drag and drop (Professional Edition).
· Added menu items for increasing and decreasing font size.
· Added menu shortcuts.
· Applying changes when restructuring a table or a view now uses a nested transaction.
· Renamed 'Create Database' menu item to 'New Database'.
· GUID values not enclosed in brackets are now accepted as valid.
· Fixed a few errors in evaluation of filter expressions.
· Updated help file with the latest features since 2.0.44.
· SQLite library 3.6.17 is now included.
· System.Data.SQLite library version 3.6.16 is now included.
August 9th, 2009· Disabled Paste from clipboard into read-only datasets.
August 9th, 2009· Added ability to Copy/Paste data, fields, indexes, constraints and triggers using the clipboard.
July 27th, 2009· Fixed "Invalid variant type" occurring on Windows 2000 when editing data in the grid.
· Fixed incorrect handling of some queries as editable instead of read-only.
· Fixed error occurring when filtering a query having an ORDER BY clause.
July 4th, 2009· Fixed error occurring when filtering a dataset with duplicate field names.
July 2nd, 2009· Added prompt for encoding when opening an empty database (when the file size is 0).
July 2nd, 2009· SQLite library 3.6.16 is now included.
July 2nd, 2009· Implemented a few UI improvenents in the field and index editors.
June 23rd, 2009· Fixed a bug in filtering on date/time fields.
· Fixed a bug in version checking.
· SQLite library 3.6.15 is now included.
June 19th, 2009· Fixed bug preventing the export to Excel for fields with no declared size.
June 5th, 2009· A few improvements to grid record scrolling and to handling of empty strings.
June 5th, 2009· Added support for viewing and editing GIF images in image editor.
June 5th, 2009· Added support for displaying GIF images in grids.
June 5th, 2009· Added scrollbars to text editor.
· A few internal fixes in the data transfer wizard.
· SQLite library 3.6.14.2 is now included.
June 5th, 2009· A few minor internal fixes.
June 5th, 2009· Modified the grid filter to be case insensitive in order to behave like a standard SQL LIKE operator.
June 5th, 2009· Fixed 'Select all' menu item not working on the Schema tab.
June 5th, 2009· A few minor internal fixes.
May 22nd, 2009· A few minor internal fixes.
May 22nd, 2009· Internal sqlite3 library is now compiled with FTS3 enabled.
· SQLite library version 3.6.14.1 is now included.
May 22nd, 2009· Modified grid code to prevent column width update when refreshing a dataset.
May 22nd, 2009· Fixed an error in the image format detection routines.
May 22nd, 2009· Fixed bug causing the encryption keys to be incorrectly persisted
May 22nd, 2009· Added a 10 seconds timeout when checking for a new version in order to prevent an application hang.
· SQLite library version 3.6.14 is now included.
May 8th, 2009· Fixed bug that may cause an application crash if the size of data in a column is greater than the declared size.
May 8th, 2009· A few cosmetic changes to the index designer.
May 8th, 2009· Fixed 'No such column' when applying changes after renaming a field.
May 8th, 2009· Fixed 'Transaction already open' when refreshing a database schema while a transaction is active.
May 8th, 2009· Fixed an error in record filter.
May 8th, 2009· Improved performance when restructuring tables.
· A few more internal fixes.
May 8th, 2009· A few improvements to the import from text files.
· The status bar now displays the progress of the current operation when restructuring a table.
May 8th, 2009· Fixed bug causing some queries to be incorrectly handled as read-only on the SQL tab.
May 8th, 2009· A few more minor corrections to the data transfer wizard.
May 8th, 2009· Fixed bug causing crash at application startup on Korean versions of Windows.
April 24th, 2009· Minor corrections to the data transfer wizard.
April 14th, 2009· Improved Unicode support.
· More encoding options on import/export from/to text files.
· An encoding detection when importing a text file has been included that seems to work reasonably well in most cases.
· Statically linked sqlite library is included.
· For more information, see "What's new in version 2.0?" in the help file.
April 14th, 2009· SQLite library 3.6.12 is now included.
March 29th, 2009· Fixed error preventing the execution of a SELECT statement in some conditions, for example if followed by comments.
March 15th, 2009· Increased width of the most recently used items in main menu and popup menus.
February 28th, 2009· Enabled word-wrapping on all SQL editors.
· Fixed error causing high CPU load when checking for new version on a computer with a firewall preventing outgoing connections.
· Fixed error caused by F6 shortcut to a disabled function in the Personal Edition.
February 16th, 2009· Fixed a minor parser error.
February 10th, 2009· Fixed a few minor issues in field editing.
January 31st, 2009· Fixed bug causing incorrect filtering for DATE, TIME and DATETIME fields.
January 17th, 2009· Fixed bug in parsing CREATE TRIGGER statements introduced in version 1.7.68.
January 5th, 2009· Fixed tab behavior on script editor windows.
December 23rd, 2008· Implemented a few optimizations for executing SQL scripts on the SQL tab and importing from CSV and SQL scripts.
December 19th, 2008· Fixed internal parser bug preventing the execution of SELECT SQL statements ending with semicolon. This bug was introduced in version 1.7.65.
May 16th, 2008· Minor user interface changes.
Find us on Google+
