Revision History

July 1, 2009: Version 2.0.41. build 1859

• Added prompt for encoding when opening an empty database (when the file size is 0).

June 28, 2009: Version 2.0.40. build 1858

• SQLite library 3.6.16 is now included.

June 25, 2009: Version 2.0.39. build 1857

• Implemented a few UI improvenents in the field and index editors.

June 22, 2009: Version 2.0.38. build 1856

• Fixed a bug in filtering on date/time fields.
• Fixed a bug in version checking.
• SQLite library 3.6.15 is now included.

June 10, 2009: Version 2.0.37. build 1855

• Fixed bug preventing the export to Excel for fields with no declared size.

June 4, 2009: Version 2.0.36. build 1854

• A few improvements to grid record scrolling and to handling of empty strings.

May 27, 2009: Version 2.0.35. build 1853

• Added support for viewing and editing GIF images in image editor.

May 26, 2009: Version 2.0.34. build 1852

• Added support for displaying GIF images in grids.

May 25, 2009: Version 2.0.33. build 1851

• Added scrollbars to text editor.
• A few internal fixes in the data transfer wizard.
• SQLite library 3.6.14.2 is now included.

May 24, 2009: Version 2.0.32. build 1850

• A few minor internal fixes.

May 23, 2009: Version 2.0.31. build 1849

• Modified the grid filter to be case insensitive in order to behave like a standard SQL LIKE operator.

May 23, 2009: Version 2.0.30. build 1848

• Fixed 'Select all' menu item not working on the Schema tab.

May 22, 2009: Version 2.0.29. build 1847

• A few minor internal fixes.

May 19, 2009: Version 2.0.28. build 1846

• A few minor internal fixes.

May 18, 2009: Version 2.0.27. build 1845

• Internal sqlite3 library is now compiled with SQLITE_ENABLE_FTS3 defined.
• SQLite library version 3.6.14.1 is now included.

May 17, 2009: Version 2.0.26. build 1844

• Modified grid code to prevent column width update when refreshing a dataset.

May 16, 2009: Version 2.0.25. build 1843

• Fixed an error in the image format detection routines.

May 15, 2009: Version 2.0.24. build 1842

• Fixed bug causing the encryption keys to be incorrectly persisted.

May 12, 2009: Version 2.0.23. build 1841

• 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 7, 2009: Version 2.0.22. build 1840

• Fixed bug that may cause an application crash if the size of data in a column is greater than the declared size.

May 7, 2009: Version 2.0.21. build 1839

• A few cosmetic changes to the index designer.

May 6, 2009: Version 2.0.20. build 1838

• Fixed 'No such column' when applying changes after renaming a field.

May 3, 2009: Version 2.0.19. build 1837

• Fixed 'Transaction already open' when refreshing a database schema while a transaction is active.

April 30, 2009: Version 2.0.18. build 1834

• Fixed an error in record filter.

April 29, 2009: Version 2.0.17. build 1832

• Improved performance when restructuring tables.
• A few more internal fixes.

April 29, 2009: Version 2.0.16. build 1831

• A few improvements to the import from text files.
• The status bar now displays the progress of the current operation when restructuring a table.

April 28, 2009: Version 2.0.15. build 1830

• Fixed bug causing some queries to be incorrectly handled as read-only on the SQL tab.

April 27, 2009: Version 2.0.14. build 1829

• A few more minor corrections to the data transfer wizard.

April 25, 2009: Version 2.0.13. build 1828

• Fixed bug causing crash at application startup on Korean versions of Windows.

April 23, 2009: Version 2.0.12. build 1826

• Minor corrections to the data transfer wizard.

April 22, 2009: Version 2.0.10. build 1821

• Fixed an error in exporting to SQL script.

April 21, 2009: Version 2.0.9. build 1820

• Added encoding and save preamble options when exporting to SQL script.
• Added encoding detection when importing from SQL script.
• Added save preamble option when exporting to text file.
• Fixed encoding error in exporting to SQL script.

April 20, 2009: Version 2.0.8. build 1818

• Added a few improvements to the error reporting.

April 19, 2009: Version 2.0.7. build 1816

• Added a few minor improvements to the data transfer wizard.

April 18, 2009: Version 2.0.6. build 1814

• Fixed an error in UpgradeLicense.

April 17, 2009: Version 2.0.5. build 1812

• Triggers are now disabled during restructuring a table.
• Added option to remove the "dbo." prefix when importing from ADO.
• Added Shift-F5 shortcut to execute the current line of SQL.

April 17, 2009: Version 2.0.4. build 1810

• Fixed error in importing currency fields from ADO.
• Fixed error in executing Lua scripts.

April 17, 2009: Version 2.0.3. build 1808

• SQLite library version 3.6.13 is now included.

April 16, 2009: Version 2.0.2. build 1807

• Fixed two errors in the HTML report generation.

April 15, 2009: Version 2.0.1. build 1803

• Minor internal changes to the UpgradeLicense tool.
• Made a few changes to the License Agreements, for both editions. Also added the License Agreement for the Personal Edition to the help file.

April 13, 2009: Version 2.0.0. build 1802

• 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 2, 2009: Version 1.7.89. build 1790

• SQLite library 3.6.12 is now included.

March 30, 2009: Version 1.7.88. build 1789

• Added support for .ICO graphic format.
• Added .sqlite file association.
• SQLite library 3.6.11 is now included.
• Fixed a few internal errors.

March 16, 2009: Version 1.7.87. build 1788

• Fixed error preventing the execution of a SELECT statement in some conditions, for example if followed by comments.

March 11, 2009: Version 1.7.86. build 1787

• Increased width of the most recently used items in main menu and popup menus.

March 10, 2009: Version 1.7.85. build 1786

• Fixed error preventing the insertion of Int64 values when editing data in the grid.

March 6, 2009: Version 1.7.84. build 1785

• Fixed error preventing the refresh of the status bar after selecting an empty table.

March 2, 2009: Version 1.7.83. build 1784

• Fixed error preventing the processing of triggers containing the % operator.

February 27, 2009: Version 1.7.82. build 1783

• 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 24, 2009: Version 1.7.81. build 1782

• Fixed internal parser error in processing triggers containing CASE statements.

February 17, 2009: Version 1.7.80. build 1781

• Fixed a few errors in HTML report generation.

February 10, 2009: Version 1.7.79. build 1780

• Fixed a minor parser error.

February 9, 2009: Version 1.7.78. build 1779

• Fixed a few minor issues in field editing.

February 5, 2009: Version 1.7.77. build 1778

• Modified grid behavior to prevent column auto-resizing when refreshing a table or view.
• Fixed error causing incorrect display of floating point values stored as text.

February 2, 2009: Version 1.7.76. build 1777

• Fixed syntax error occurring when filtering views.

January 30, 2009: Version 1.7.75. build 1776

• Fixed bug causing incorrect filtering for DATE, TIME and DATETIME fields.

January 23, 2009: Version 1.7.74. build 1775

• Fixed filter error for regional settings using decimal separator other than '.'
• Removed annoying confirmation dialog when closing a database.

January 15, 2009: Version 1.7.73. build 1774

• Fixed bug in parsing CREATE TRIGGER statements introduced in version 1.7.68.

January 5, 2009: Version 1.7.72. build 1773

• Added 'Close all databases' menu option.
• Fixed bug causing the hex editor to always show up on the first monitor instead of the active monitor.

January 3, 2009: Version 1.7.71. build 1772

• Fixed tab behavior on script editor windows.

January 2, 2009: Version 1.7.70. build 1771

• Fixed button alignment on the text export form.

December 30, 2008: Version 1.7.69. build 1770

• Fixed a few issues related to importing from CSV files.

December 21, 2008: Version 1.7.68. build 1769

• Implemented a few optimizations for executing SQL scripts on the SQL tab and importing from CSV and SQL scripts.

December 20, 2008: Version 1.7.67. build 1768

• SQLite library 3.6.7 included.
• Minor internal fixes.

December 15, 2008: Version 1.7.66. build 1767

• Fixed internal parser bug preventing the execution of SELECT SQL statements ending with semicolon. This bug was introduced in version 1.7.65.

December 13, 2008: Version 1.7.65. build 1766

• Added option to cancel import from CSV files.
• Improved performance for executing queries on the SQL tab.

December 11, 2008: Version 1.7.64. build 1765

• Improved performance for import from CSV files.

December 10, 2008: Version 1.7.63. build 1764

• Fixed error preventing the import of CSV files with large number of lines.

December 7, 2008: Version 1.7.62. build 1763

• Fixed a few errors in export to XML and EXCEL.

December 3, 2008: Version 1.7.61. build 1762

• Fixed bug causing the reset of date and time format settings in response to WM_WININICHANGE message.

November 28, 2008: Version 1.7.60. build 1761

• SQLite library 3.6.6.2 is now included.

November 24, 2008: Version 1.7.59. build 1760

• Fixed button alignment on the text import dialog.
• Fixed access violation occurring when exporting to Excel.

November 21, 2008: Version 1.7.58. build 1759

• Fixed error occurring when trying to view an empty field in the Hex editor.
• SQLite library 3.6.6 is now included.

November 18, 2008: Version 1.7.57. build 1758

• Improved error handling for preventing an application crash when reading DATETIME values in a format not recognized by the program.

November 17, 2008: Version 1.7.56. build 1757

• Fixed a few button alignment issues.

November 16, 2008: Version 1.7.55. build 1756

• SQLite library 3.6.5 is now included.
• Fixed a few internal issues.

November 13, 2008: Version 1.7.54. build 1755

• Fixed "field not found" error that might occur when switching between tables when a filter is active.

November 9, 2008: Version 1.7.53. build 1753

• Fixed bug preventing the conversion of wide string to UTF-8 when importing from ADO data source.

November 7, 2008: Version 1.7.52. build 1752

• Fixed bug causing a database to be created with a page size of 1024 regardless of user selection.

November 6, 2008: Version 1.7.51. build 1751

• Null values are now displayed as <null>.

November 5, 2008: Version 1.7.50. build 1750

• Fixed bug causing incorrect update of null values for fields of type BLOB and CHAR of undeclared size.

November 1, 2008: Version 1.7.49. build 1749

• Added option to switch between large and small toolbar icons.
• Fixed a few toolbar visibility issues.
• Fixed access violation that may occur when using multiple monitors and removing one of them while the program is running.

October 28, 2008: Version 1.7.48. build 1748

• Fixed bug causing DATE fields to be saved using the DATETIME format.

October 27, 2008: Version 1.7.47. build 1747

• Added support for encrypted databases.
• Added feature comparison to the help file.
• Fixed bug causing incorrect display of null fields in the hex editor.

October 23, 2008: Version 1.7.46. build 1746

• Fixed bug introduced in 1.7.45 causing incorrect display of the record count.

October 22, 2008: Version 1.7.45. build 1745

• New feature: added 'Schema' tab (Professional Edition).
• Fixed incorrect parsing of CREATE TABLE when using multiple ON CONFLICT clauses.

October 21, 2008: Version 1.7.44. build 1744

• Fixed incorrect parsing of ON CONFLICT clause for unnamed unique constraints.
• Fixed incorrect data display for aggregate fields.
• Fixed incorrect setting of NotNull flag when adding a new field.

October 20, 2008: Version 1.7.43. build 1743

• Fixed 'cannot focus' error when editing a table or view, introduced in 1.7.42.

October 20, 2008: Version 1.7.42. build 1742

• Added global option to display or hide record numbers (in Tools/Options/Data).
• The table name (or the view name) edit box is now focused when using New Table (or New View) command.
• Fixed bug preventing the full view definition to be exported to an SQL script.

October 20, 2008: Version 1.7.41. build 1741

• Fixed a side effect caused by removing the 'limit number of rows' option.

October 19, 2008: Version 1.7.40. build 1740

• Removed obsolete 'limit number of rows' feature. It was needed in version 1.0, but in the current version the number of records retrieved when opening a dataset is limited internally to 256.
• Code refactoring for improving the accuracy of the data displayed in the hex editor.

October 18, 2008: Version 1.7.39. build 1739

• Added option to show or hide filter rows on grids.
• Fixed filter not working on boolean fields on queries.

October 18, 2008: Version 1.7.38. build 1738

• Added type mapping BOOL -> Boolean.
• Fixed bug preventing the display of data in the grid on the Scripting tab.

October 17, 2008: Version 1.7.37. build 1737

• Added export to XML (experimental).
• Enabled export functions for all grids.
• Added option to hide or show toolbar.

October 16, 2008: Version 1.7.36. build 1736

• Fixed bug introduced in 1.7.35 causing incorrect display of text fields in databases using UTF-16 encoding.

October 15, 2008: Version 1.7.35. build 1735

• Modified column auto-adjust behavior. A column will not decrease its size anymore after being manually resized.
• SQLite library 3.6.4. is now included.

October 15, 2008: Version 1.7.34. build 1734

• Added type mapping BLOB_TEXT -> Blob.
• Added rules for determining the column type for declared types not in the list. These rules are similar to the rules for determining column affinity (i.e. if the declared type contains 'INT' it will be mapped to an integer; if it contains 'TEXT' it will be mapped to string and so on. For previous versions declared types not in the list were mapped to string.
• Fixed 'no such column' error when filtering on a boolean field.
• Fixed 'no such column' error when attempting to filter by record number.
• Fixed bug causing table names beginning with 'sqlite' to be considered system tables and not show up in the list, instead of table names beginning with 'sqlite_'.
• Fixed a data restructuring bug.

October 15, 2008: Version 1.7.33. build 1733

• Fixed bug introduced in 1.7.28 causing an error when deleting the last record in a table.

October 14, 2008: Version 1.7.32. build 1732

• The date and time values are now stored in the database in the following format: 'YYYY-MM-DD HH:MM:SS.SSS'.
• Replaced some of the icons used by the program.

October 11, 2008: Version 1.7.31. build 1731

• Fixed bug introduced in 1.7.28 causing access violation when adding an index.
• Fixed background color for application icon.

October 10, 2008: Version 1.7.30. build 1730

• Fixed a few more issues related to data filtering.
• Improved scrollbar behavior for large datasets.

October 9, 2008: Version 1.7.29. build 1729

• Fixed a few issues related to data filtering. Also improved filter performance.

October 8, 2008: Version 1.7.28. build 1728

• Added grid filter option (experimental).
• Added file association option.
• Fixed bug causing UTF-8 encoding option to be disabled by default for a new installation.
• Removed obsolete Auto-refresh feature.

October 1, 2008: Version 1.7.27. build 1727

• Fixed bug causing 'No records' error after deleting a group of records selected in the grid.
• Minor user interface fixes.

September 28, 2008: Version 1.7.26. build 1726

• Added 'Open Demo Database' menu item.
• Auto refresh data is now enabled by default for a new installation.
• Minor user interface fixes.

September 19, 2008: Version 1.7.25. build 1725

• 'Schema changed' errors are no longer displayed when refreshing schema.
• Fixed bug causing incorrect display of GUID fields in the hex editor.

September 19, 2008: Version 1.7.24. build 1724

• Fixed bug causing incorrect update of GUID fields when editing data in the grid.

September 18, 2008: Version 1.7.23. build 1723

• Fixed bug causing an error whan refreshing schema for a table containing triggers.

September 17, 2008: Version 1.7.22. build 1722

• Fixed bug causing the display of system table sqlite_sequence in the object tree.
• Added a few improvements to the Data Transfer Wizard.
• Fixed a few issues in importing text files.

September 14, 2008: Version 1.7.21. build 1721

• Added a few improvements to the Data Transfer Wizard.

September 13, 2008: Version 1.7.20. build 1720

• The program now remembers the location of the last script used by the Data Transfer Wizard.
• Fixed bug preventing saving data to a script with the Data Transfer Wizard if table structure was not selected in the options.

September 2, 2008: Version 1.7.19. build 1719

• Fixed bug causing 'Range check error' when deleting index.
• Fixed a couple bugs in index editing.

August 31, 2008: Version 1.7.18. build 1718

• SQLite DLL version 3.6.2 is now included.
• Removed single quote option introduced in 1.7.17 because it is not fully supported by the Query Builder.

August 30, 2008: Version 1.7.17. build 1717

• Added single quote option for SQL code generation.
• Fixed some internal SQL parser errors.

August 27, 2008: Version 1.7.16. build 1716

• Fixed bug causing the incorrect saving of the SQL history.

August 26, 2008: Version 1.7.15. build 1715

• Fixed bug preventing the SQL builder from using the selected quote characters when generating queries.

August 25, 2008: Version 1.7.14. build 1714

• Removed internal limitation of 2 kB for trigger SQL.
• Fixed bug causing a conversion error when editing trigger fields.

August 17, 2008: Version 1.7.13. build 1713

• Fixed bug that may cause an invalid field ordering when importing from an ADO data source.

August 15, 2008: Version 1.7.12. build 1712

• Fixed bug causing "Invalid variant type" error on Windows 2000.

August 10, 2008: Version 1.7.11. build 1711

• SQLite3.dll version 3.6.1 is now included.

August 2, 2008: Version 1.7.10. build 1710

• Fixed "Table not found" error occurring after executing a Lua or Pascal script displaying data in the grid. This error was introduced in version 1.7.9.

August 2, 2008: Version 1.7.9. build 1709

• Performance improvements for executing Lua and Pascal scripts.

July 30, 2008: Version 1.7.8. build 1708

• Fixed bug preventing the display of data in the grid for Lua and Pascal scripts.

July 23, 2008: Version 1.7.7. build 1707

• Added option to rename indexes when importing data by prefixing the index name with table name. This will prevent 'index already exists' error when importing an Access database having duplicate index names.

July 18, 2008: Version 1.7.6. build 1706

• Fixed bug causing the program to crash when closing the Options or Index editor dialogs. I have only been able to reproduce this error when the PowerPro desktop utility was installed and running on the same computer.

July 15, 2008: Version 1.7.5. build 1705

• Added 'show cell hints' option.
• Fixed bug causing incorrect expanding of tree items when refreshing database schema.

July 14, 2008: Version 1.7.4. build 1704

• Fixed a few theme related issues.
• Improved screen refresh after changing options.

July 13, 2008: Version 1.7.3. build 1703

• Fixed bug that might cause the splash screen to remain visible if an error occurs during program initialization.

July 11, 2008: Version 1.7.2. build 1702

• Modified import from ADO to convert WideString (UCS2) fields to UTF-8 unless default type mapping for CHAR has been changed to WideString.

July 7, 2008: Version 1.7.1. build 1701

• Database tree does not expand anymore after restructuring a table or view.

July 6, 2008: Version 1.7.0. build 1700

• Added custom themes support.
• New option: auto check for updates.
• New option: remember open databases.
• New option: select grid background color.
• New option: get record count for queries.

June 28, 2008: Version 1.6.74. build 1595

• Improved integrity check results dialog.

June 23, 2008: Version 1.6.73. build 1594

• Fixed internal error causing loss of data in the last column when restructuring a table.

June 17, 2008: Version 1.6.72. build 1592

• Fixed internal error preventing the update of BLOB fields.

June 16, 2008: Version 1.6.71. build 1591

• Fixed error preventing transfer of views in Data Transfer Wizard.

June 7, 2008: Version 1.6.70. build 1589

• Fixed error in updating date and time fields.

May 26, 2008: Version 1.6.69. build 1585

• Modified constraint editors to allow unnamed constraints.
• Added label that displays whether a query is editable and which key fields are being used.

May 20, 2008: Version 1.6.68. build 1582

• Fixed error preventing database schema auto-refresh after executing a query that may have modified the schema.

May 20, 2008: Version 1.6.67. build 1581

• Fixed parsing error when processing unnamed constraints.

May 18, 2008: Version 1.6.66. build 1579

• Improved collation handling when restructuring a table.

May 15, 2008: Version 1.6.65. build 1577

• Minor user interface changes.

May 14, 2008: Version 1.6.64. build 1575

• Now includes sqlite.dll 3.5.9.
• Removed workaround for bug 3102 in SQLite csvtrac as it has been fixed fixed in 3.5.9.
• Added consistency check before applying changes when restructuring a table.
• Fixed error preventing the resizing of controls on the triggers tab.
• Minor user interface changes.

May 8, 2008: Version 1.6.63. build 1568

• Fixed access violation when creating a new table.

May 7, 2008: Version 1.6.62. build 1567

• Fixed bug in table restructuring introduced in version 1.6.61.

May 7, 2008: Version 1.6.61. build 1566

• Implemented workaround for bug 3102 in SQLite csvtrac causing error "The Database disk image is malformed" when restructuring a table containing comments in the CREATE TABLE SQL.
• Further improvements to error handling when importing an incorrectly encoded CSV file.

May 6, 2008: Version 1.6.60. build 1560

• Improved error handling when importing an incorrectly encoded CSV file.

May 5, 2008: Version 1.6.59. build 1559

• Fixed error causing the field editor to display the wrong field type.

May 5, 2008: Version 1.6.58. build 1558

• Minor user interface changes.

May 3, 2008: Version 1.6.57. build 1547

• Minor updates to the help file.
• Fixed some repainting problems.

May 3, 2008: Version 1.6.56. build 1542

• Replaced 'Export to CSV' and 'Import CSV file' with 'Export to text file' and 'Import text file' respectively. The following delimiters are accepted: comma, semicolon and TAB.

April 30, 2008: Version 1.6.55. build 1524

• Minor user interface improvements.

April 28, 2008: Version 1.6.54. build 1520

• Minor user interface improvements.

April 27, 2008: Version 1.6.53. build 1518

• Improved error handling when the current database is locked by an external process.
• Now includes sqlite.dll 3.5.8.

April 24, 2008: Version 1.6.52. build 1515

• Fixed error in trigger editor.

April 22, 2008: Version 1.6.51. build 1513

• Fixed another error in parsing triggers.

April 20, 2008: Version 1.6.50. build 1511

• Fixed a few errors in parsing triggers.

April 19, 2008: Version 1.6.49. build 1510

• Fixed error applying changes after editing a view.

April 18, 2008: Version 1.6.48. build 1508

• Fixed index out of range error when refreshing database schema.

April 18, 2008: Version 1.6.47. build 1506

• Object names in the tree view are now re-sorted after adding or renaming a table or a view.

April 17, 2008: Version 1.6.46. build 1505

• Fixed duplicate application icon on taskbar.

April 16, 2008: Version 1.6.45. build 1503

• Drag and drop operations were not working. This has been fixed.
• Fixed access violation when clearing an image in the image editor.
• Fixed error preventing editing of field aliases in the Query Builder.
• Fixed error preventing adding SQL queries other than SELECT to history.
• Fixed grid scrolling error.

April 15, 2008: Version 1.6.44. build 1493

• Fixed an internal SQL parser error.

April 14, 2008: Version 1.6.43. build 1492

• Fixed a few errors in trigger editing.

April 6, 2008: Version 1.6.42. build 1489

• Improved error handling when refreshing a database schema after deleting table fields that were referenced in a view.
• Fixed a few other errors in user interface.

April 2, 2008: Version 1.6.41. build 1482

• Fixed minor error in index editing.

April 1, 2008: Version 1.6.40. build 1481

• Volume discounts and site licenses are now available.

March 31, 2008: Version 1.6.39. build 1477

• Fixed error in handling EXPLAIN commands.
• Fixed a few broken hyperlinks in help file.

March 20, 2008: Version 1.6.38. build 1475

• Fixed access violation occurring when deleting a table or a view.
• Fixed control layout on the field editor.
• Fixed auto-refresh not executing after running a query that may modify the database schema.
• Now includes sqlite.dll 3.5.7.

March 18, 2008: Version 1.6.37. build 1472

• Fixed error preventing the data refresh after a INSERT, UPDATE or DELETE SQL when Auto-refresh was selected.

March 15, 2008: Version 1.6.36. build 1470

• Fixed error preventing the opening of databases at startup when one of them is unavailable.

March 12, 2008: Version 1.6.35. build 1468

• Changed the location of the settings from the application data folder to the registry.
• Added 'Reset to default mappings' function on the Options dialog.

March 10, 2008: Version 1.6.34. build 1458

• Minor internal bug fixes.

March 5, 2008: Version 1.6.33. build 1451

• When importing data from ADO into a SQLite data source, if no data types are mapped to WideString then Unicode data (UCS-2) will be converted to UTF-8.

March 4, 2008: Version 1.6.32. build 1447

• Full path to database is now displayed in title bar.
• Changed default mappings from WideString to String for NVARCHAR, NVARCHAR2, NCHAR, NTEXT.
• Fixed a few alignment problems on the field editor.
• Other internal bug fixes.

March 2, 2008: Version 1.6.31. build 1445

• Minor user interface fixes.

March 1, 2008: Version 1.6.30. build 1443

• Fixed object tree repainting error.
• Fixed error preventing clearing of the query builder object list after closing the current database.

February 26, 2008: Version 1.6.29. build 1433

• Minor user interface fixes.

February 25, 2008: Version 1.6.28. build 1429

• Added option for quoting identifiers with square brackets or double quotes.

February 24, 2008: Version 1.6.27. build 1426

• Added 'Empty table' menu option.
• Minor bug fixes.

February 20, 2008: Version 1.6.26. build 1401

• Added standard menu items (cut/copy/paste/delete/select all) to all the edit windows.
• Added 'Delete record' menu items to grid popup menu.

February 14, 2008: Version 1.6.25. build 1397

• The status bar now shows the number of rows affected by the last INSERT, DELETE or UPDATE query, and the total number of changes since the database was open.

February 12, 2008: Version 1.6.24. build 1395

• Indexes are now sorted alphabetically.

February 11, 2008: Version 1.6.23. build 1392

• Fixed error preventing execution of Pascal and Lua scripts.
• Fixed splitters on SQL and Scripting tabs.

February 3, 2008: Version 1.6.21. build 1383

• Minor GUI improvements.

January 26, 2008: Version 1.6.20. build 1363

• Program now remembers the directory where the last SQL script was saved.
• Added 'Clear SQL' option in SQL window pop-up menu.
• Added 'Clear script' option in script window pop-up menu.
• Minor GUI corrections.

January 22, 2008: Version 1.6.19. build 1360

• Fixed painting problem and memory leak in Query Builder (Professional Edition).
• Fixed internal error causing application shutdown (Personal Edition).

January 19, 2008: Version 1.6.18. build 1342

• Improved exception handling when trying to export to Excel when Excel is not installed on the computer.
• Minor GUI corrections.

January 17, 2008: Version 1.6.17. build 1339

• Added 'Export to Excel' (Professional Edition).
• Fixed error in applying settings preventing application startup if previous session was closed while in minimized state.
• Fixed internal error in handling NVARCHAR fields.

January 13, 2008: Version 1.6.16. build 1335

• Fixed error in 'Export to CSV' causing the record number to be exported in the CSV file.

January 12, 2008: Version 1.6.15. build 1333

• Added 'Export to CSV' and 'Import CSV file' (Professional Edition).
• Fixed installer error preventing installation of script samples.

January 3, 2008: Version 1.6.14. build 1327

• Fixed internal error in exception handling.

January 3, 2008: Version 1.6.13. build 1323

• Added a few improvements to the data transfer wizard, such as: the program will remember the last ADO connection string.
• Fixed internal error in parametrized queries causing empty strings ("") to be updated as null values.

December 31, 2007: Version 1.6.12. build 1306

• Fixed internal error introduced in version 1.6.11 causing possible data corruption and "Data transfer error: Abort due to constraint violation" when using the data transfer wizard.

December 30, 2007: Version 1.6.11. build 1304

• Modified all data inserts and updates to use parametrized queries, for allowing handling of large string and blob fields.

December 27, 2007: Version 1.6.10. build 1300

• Fixed internal parsing error with SQL statements containing TAB characters.

December 26, 2007: Version 1.6.9. build 1298

• Fixed internal errors in executing SQL queries containing comments.

December 25, 2007: Version 1.6.8. build 1294

• Modified the way the text fields are handled internally, for preventing the 'unrecognized token' error when the data contains null bytes.

December 24, 2007: Version 1.6.7. build 1290

• Fixed internal error in SQL parser when processing comments.
• Minor user interface changes.

December 23, 2007: Version 1.6.6. build 1288

• Fixed bug preventing generating an HTML report when selecting zero records per page.

December 18, 2007: Version 1.6.5. build 1286

• Added 'Set to NULL' option to grid pop-up menu.
• SQLite library 3.5.4 included.

December 13, 2007: Version 1.6.4. build 1284

• Fixed error opening configuration file if current user name contains unicode characters.

December 6, 2007: Version 1.6.3. build 1278

• Fixed internal parsing error in 'BEFORE UPDATE' and 'AFTER UPDATE' triggers.

December 2, 2007: Version 1.6.2. build 1275

• Fixed error preventing the opening of a database containing unicode characters in the file name.
• SQLite library 3.5.3 included.

November 18, 2007: Version 1.6.1. build 1271

• Changed the location of the data and configuration files from the installation folder to the application data and user data folders, for compatibility with Windows Vista.
• SQLite library 3.5.2 included.

November 8, 2007: Version 1.6.0. build 1251

• Encoding (UTF-8 or ASCII) is now a user option available in Tools/Options. The default encoding is UTF-8.
• Internal refactoring and optimizations.
• Hex editor now closes when pressing ESC.

October 30, 2007: Version 1.5.40. build 1229

• Fixed 'table already exists' error after executing a CREATE TABLE sql.
• Upgraded some internal components.

October 23, 2007: Version 1.5.39. build 1212

• Fixed internal bug preventing table restructuring. This bug was introduced in version 1.5.38.
• Fixed: when refreshing data and the table had been deleted by an external program, it was not deleted from the list.
• Fixed bug preventing the execution of an SQL query after loading from a file.

October 22, 2007: Version 1.5.38. build 1207

• Fixed bug preventing the editing of tables and queries containing a declared field named ROWID.
• Minor user interface changes.

October 21, 2007: Version 1.5.37. build 1203

• Fixed bug preventing editing of triggers. This was introduced in version 1.5.34 when adding UTF-8 support.
• Minor user interface changes.

October 19, 2007: Version 1.5.36. build 1196

• Minor corrections in the help file.

October 18, 2007: Version 1.5.35. build 1192

• Fixed internal error preventing execution of multiple sql statements when one of them was 'CREATE TABLE...'.

October 13, 2007: Version 1.5.34. build 1174

• Added UTF-8 support.
• Added UTF-8 table translated in various languages in the demo database.
• SQLite library 3.5.1 included.

September 26, 2007: Version 1.5.33. build 1160

• Modified default data mappings so that all integer types are handled internally as 64 bit integers.

September 20, 2007: Version 1.5.32. build 1158

• Modified grid options to allow navigating through cells using the TAB key.

Revision History

September 19, 2007: Version 1.5.31. build 1156

• Fixed error preventing modifying the precision for a numeric field.

August 8, 2007: Version 1.5.30. build 1152

• Fixed parser error causing collate options not being displayed in indexes.
• Other minor bug fixes.

August 6, 2007: Version 1.5.29. build 1150

• Minor bug fixes.

July 28, 2007: Version 1.5.28. build 1148

• Improved error handling when refreshing database schema.

July 24, 2007: Version 1.5.27. build 1145

• Fixed database refresh problem when the schema is changed by another application.

July 21, 2007: Version 1.5.26. build 1140

• Fixed refresh problem in SQL window.

July 13, 2007: Version 1.5.25. build 1135

• Added support for GUID fields, stored in the database as 16 byte BLOB. If you are upgrading on top of an existing installation you have to delete the .cfg file in the installation directory to enable this feature. Alternatively you can manually ad a GUID -> Guid mapping in Tools/Options/Type mappings.

July 5, 2007: Version 1.5.24. build 1132

• Minor bug fixes.
• SQLite library 3.4.0 included.

April 29, 2007: Version 1.5.23. build 1126

• Default font on Vista is now 'Segoe UI'.
• Fixed issue with default database alias if file name contains more than one '.'.
• Fixed minor font issues.
• SQLite library 3.3.17 included.

March 30, 2007: Version 1.5.22. build 1121

• Fixed: grid not refreshed after transaction rollback.
• Fixed table name formatting in trigger display.

February 21, 2007: Version 1.5.21. build 1119

• Fixed "Cannot update undo storage" error when clearing empty blob field.
• Fixed "Format '%Y' invalid or incompatible with argument" error when refreshing tables with triggers containing "%" characters.

February 20, 2007: Version 1.5.20. build 1115

• Fixed access violation when changing settings.

February 13, 2007: Version 1.5.19. build 1113

• Fixed incorrect handling of empty ("") fields as NULL fields.
• SQLite library 3.3.13 included.

February 4, 2007: Version 1.5.18. build 1109

• Fixed "Bookmark not found" error in the field editor.

February 3, 2007: Version 1.5.17. build 1108

• Fixed several bugs in the field editor.

January 28, 2007: Version 1.5.16. build 1106

• Fixed: Customized data type mappings are persisted but are not applied until the Options popup is seen.
• Improved error handling for invalid date/time fields.
• Data mappings are now sorted.
• SQLite library 3.3.12 included.

December 21, 2006: Version 1.5.15. build 1099

• Enabled the extension loading mechanism by calling sqlite3_enable_load_extension after a database is open. More information can be found here.

December 10, 2006: Version 1.5.14. build 1095

• Minor internal changes.

December 7, 2006: Version 1.5.13. build 1094

• Fixed access violation on refresh data.

December 6, 2006: Version 1.5.12. build 1090

• Minor internal changes.

December 3, 2006: Version 1.5.11. build 1078

• Minor internal changes.

December 2, 2006: Version 1.5.10. build 1050

• Limited grid column width to a reasonable size when the field names are too long.

December 1, 2006: Version 1.5.9. build 1037

• Fixed grid refresh error on SQL tab.

October 30, 2006: Version 1.5.8. build 1036

• Minor internal changes.

October 28, 2006: Version 1.5.7. build 1028

• Added custom exception handler that displays more context information about the error.
• Fixed error preventing the update of fields with default values when inserting records in the grid.

October 27, 2006: Version 1.5.6. build 1023

• Improved error handling during startup.

October 26, 2006: Version 1.5.5. build 1017

• Minor bug fixes.

October 25, 2006: Version 1.5.4. build 1011

• SQLite Expert will now open a database passed as a command-line parameter.
• Minor bug fixes.

October 24, 2006: Version 1.5.3. build 1007

• Fixed syntax error when creating/updating a view trigger.
• Enabled multi-selection for all data grids
• New DATE and DATETIME editors.
• Changed internal handling for boolean fields as follows: 0, 'false', 'False', 'FALSE', 'f', 'F' will be interpreted as False; 1 (or any non-zero integer), 'true', 'True', 'TRUE', 't', 'T' will be interpreted as True.

October 2, 2006: Version 1.5.2. build 981

• Changed the quoting characters of the Query Builder from "" to [].

October 31, 2006: Version 1.5.1. build 980

• Modified the Query Builder to automatically generate field aliases. This is a workaround for a known issue in SQLite: invalid field names in views. For more information see 'Known Issues' in the Help file.
• Added more Lua and Pascal scripting examples in the Help file.
• Other cosmetic changes.

October 29, 2006: Version 1.5.0. build 978

• Added Lua and Pascal scripting support.
• Replaced the old Query Builder with Active Query Builder. The new Query Builder supports unions, sub-queries, join properties, as well as saving and loading SQL scripts.

October 20, 2006: Version 1.4.4. build 946

• Fixed: 'not an error' error when posting a record.

October 15, 2006: Version 1.4.3. build 943

• Modified the error handling to display more meaningful error messages.

October 12, 2006: Version 1.4.2. build 942

• Fixed 'Integer overflow' error when navigating at end of table.

October 11, 2006: Version 1.4.1. build 941

• Improved loading time for a table or query by skipping record counting completely.
• Fixed error: after modifying a record in the grid, clicking the Refresh button before posting data loses changes.

October 9, 2006: Version 1.4.0. build 940

• Added 'Generate HTML Report' option in grid popup menu (Professional Edition).
• Minor bug fixes.
• Now includes SQLite library 3.3.8.

October 8, 2006: Version 1.3.15. build 933

• Added 'Reopen Database...' menu item.
• Fixed error in datetime conversion that occurs when entering a datetime value with more than 3 digits for milliseconds.

October 7, 2006: Version 1.3.14. build 930

• Improved loading time for tables and queries by skipping the counting of records when reaching 50000. In this case the status bar will show something like 'Record 1 of >50000'. The displayed record count will be updated to the real value if the end of table is reached when scrolling down in the grid.

October 5, 2006: Version 1.3.13. build 928

• Hex editor is now available for all fields.
• Text editor is now available also for widestring fields.

October 3, 2006: Version 1.3.12. build 918

• Enforced decimal separator to '.' when posting data to a table.

October 3, 2006: Version 1.3.11. build 917

• Added support for Wide Memo fields.
• Fixed bug preventing the import of tables with spaces in table name.
• Fixed performance bottleneck in Data Transfer Wizard. Now the transfer between two SQLite databases is much faster.
• Fixed 'Field not found' error when attempting to modify a non-live query.

October 2, 2006: Version 1.3.10. build 915

• Record number now shows as the first column in the grid.
• Fixed time separator (changed from '.' to ':').

October 1, 2006: Version 1.3.9. build 913

• Grid column widths now adjust dynamically to text length.

September 29, 2006: Version 1.3.8. build 904

• Fixed: when editing data in the grid, moving to another row using the mouse wheel loses the changes to the current record.

September 28, 2006: Version 1.3.7. build 903

• Fixed selecting the wrong row after reordering fields using 'Move up' or 'Move down' buttons.
• Other cosmetic changes.

September 27, 2006: Version 1.3.6. build 886

• Fixed "Out of memory while expanding memory stream" error when scrolling down a table with BLOB fields, or CHAR fields with no declared size.
• Fixed error: drop-down list not populated with available data types in field editor.

September 24, 2006: Version 1.3.5. build 881

• Fixed bug in date and time format.

September 24, 2006: Version 1.3.4. build 878

• Other internal bug fixes.

September 24, 2006: Version 1.3.3. build 877

• Fixed bug with check constraints not showing in the grid.

September 23, 2006: Version 1.3.2. build 868

• Renamed 'Register database' menu item to 'Open database' and 'Unregister database' to 'Close database'.
• Changed the option to limit the number of records to be enabled by default.
• Changed the internal handling of date and time fields to recognize the data stored in the format 'YYYY-MM-DDTHH:MM:SS.SSS' as described in the SQLite documentation. The date and time fields will be stored in this format starting with version 1.3.2. However, for compatibility with older versions, the program will recognize date and time fields stored in the old Delphi TDateTime format (floating point). The integral part of a Delphi TDateTime value is the number of days that have passed since 12/30/1899. The fractional part of the TDateTime value is fraction of a 24 hour day that has elapsed.

September 21, 2006: Version 1.3.1. build 868

• Added 'Select columns' dialog for data grids.
• Changed data grids implementation to use a sliding window so they don't load all the data in memory, thus improving both performance and memory usage for large tables or queries.
• Fixed 'Invalid field size' when declaring a float field with a size different than 0.
• Fixed invalid record number after scrolling.
• Fixed error displaying pictures with Width = 0 or Height = 0.

September 16, 2006: Version 1.2.4. build 857

• Optimized opening of databases and extraction of metadata.
• Reduced flickering.

September 14, 2006: Version 1.2.3. build 827

• Added splash screen with progress bar.
• Changed the about box.

September 13, 2006: Version 1.2.2. build 817

• Fixed bug in Data Transfer Wizard when importing from an Access database.
• Further startup speed improvements by wrapping metadata extraction in a transaction.

September 13, 2006: Version 1.2.1. build 802

• Added support for precision in numeric fields.
• Improved startup speed by optimizing parsing of metadata information.

September 11, 2006: Version 1.2.0. build 788

• New feature: added 'Stop Query' button for interrupting the execution of long running queries.
• Fixed 'no such column' error in SQL Builder when some tables do not have any selected fields.
• Improved handling of INTEGER PRIMARY KEY.

September 5, 2006: Version 1.1.5. build 786

• Fixed bug in handling INTEGER PRIMARY KEY when a UNIQUE constraint was present on a different field.

August 25, 2006: Version 1.1.4. build 781

• Starting with version 1.1.4, SQLite Expert is available in two editions: Personal and Professional.
• Fixed minor cosmetic issues.

August 19, 2006: Version 1.1.3. build 765

• Fixed problem with sqlite.dll version 3.3.7.
• Fixed refresh problem when displaying data as text.

August 19, 2006: Version 1.1.2. build 761

• Unfortunately I realized that the latest release of the sqlite.dll (version 3.3.7) breaks a few features in SQLite Expert. I am currently investigating this, and until I fix these issues the SQLite Expert installation will include sqlite.dll version 3.3.6. If you have downloaded SQLite Expert 1.1.1, I recommend you upgrade to version 1.1.2 or replace sqlite.dll with the older version 3.3.6.

August 14, 2006: Version 1.1.1. build 754

• Fixed error in parsing check constraints.
• Fixed "unassigned KeyFieldName" error when editing live queries.
• Added support for unnamed check and unique constraints.
• Other cosmetic changes.
• Includes SQLite DLL version 3.3.7.

July 29, 2006: Version 1.1.0 build 727

• Fixed "Grid index out of range" bug in data grids.
• Fixed row resizing error in data grids.
• Improved SQL parser.
• Improved trigger edit dialog.
• Added disabled icons.
• Added support for unique and check constraints.

June 27, 2006: SQLite Expert 1.0.0 released.

---

Copyright © 2005–09, Bogdan Ureche. All rights reserved.
Last modified: July 1, 2009.