Revision History

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.