Full Revision History

This page provides a detailed summary of changes to SQLite Expert. For a high-level summary, see the Release History.

• Added word-wrap option for SQL editors.

• Fixed child fields not being renamed when renaming field in tables with multiple foreign keys.

• Fixed tab character not expanded in the grid and in the tooltip windows.

• 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.

• SQLite library 3.7.2 included.

• Fixed navigator buttons not working on the SQL tabs.

• Fixed record number not showing on the SQL grids.

• SQLite library 3.7.1 included.

• SQL Builder now generates queries in a new SQL tab to preserve existing queries.

• Added option to open multiple SQL tabs.
• Added WAL mode to the journal_mode drop-down list on Database tab.

• Fixed "cannot focus invisible window" error when attempting to create a new table.

• SQLite library 3.7.0.1 included.

• Unfortunately the fix in 3.0.36 introduced a bug so the changes have been rolled back.

• 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.

• Fixed error when copying a large number of records to clipboard.

• Fixed 'invalid typecast' error when importing GUID fields from ADO data source.

• Modified field editor to allow empty field types.
• Fixed an error when importing CSV file into an existing table.

• SQLite library version 3.7 included.

• Fixed a grid filter issue.

• Fixed a data refresh issue.

• Minor UI fixes.

• Fixed an error in parsing foreign keys.

• Minor UI fixes.

• Fixed error in evaluating dependencies between objects in data transfer operations.

• Fixed error affecting drag and drop operations from Windows Explorer.

• Added warning when constraints prevent copying the data to the new table during restructuring a table.

• Added option to enable cell auto height.
• Fixed a parsing error in intellisense.

• Minor UI fixes.

• Fixed a window resize issue.

• Fixed variant conversion error in text import.

• Minor improvements to Excel export.

• Text editor is now enabled regardless of the data type. Use with caution.

• Fixed an issue with the SQL window scrollbars at program startup.

• The text, image and blob editors now accept files from Windows Explorer using drag and drop operations.

• Added support for custom delimiters when exporting/importing to/from text files.

• Added option to allow only one instance of the application.
• Selected columns are now persisted.
• Indexes associated with unique constraints are no longer exported in the Data Transfer Wizard.

• Fixed an issue in editing primary keys in a table having unique constraints.

• Fixed issue with print preview scrollbars when thumb tracking is enabled.

• Grid rows now resize height with the size of the text.

• Fixed issue with multiline cells only displaying the first line on the print preview.

• Fixed a repaint issue with a menu item caption.
• Replaced icon for main form as it was causing a GDI error on some systems.

• Rolled back cell auto resize due to conflict with scrollbars.

• Added word wrapping option to text editor.
• Grid rows now resize height with the size of the text. This fixes an issue with multiline cells only displaying the first line on the print preview.

• Fixed print preview displaying page orientation as portrait after being set to landscape.
• Position of data editor windows is now persisted.
• Added busy timeout currently set to 3000 ms to improve concurrent access.

• Fixed bug in parsing foreign keys.
• Replaced some of the toolbar icons.

• Fixed incorrect edition displayed on caption bar in Personal Edition.

• Fixed bug preventing attached databases from being restored at application startup.

• Fixed a bug in parsing table names containing punctuation characters.

• Added option to open record editor when dbl-clicking on a record.
• Fixed a startup error on Korean Windows.

• Minor UI corrections.

• Added skin library.
• Added printing library.

• Fixed bug in handling savepoints with duplicate names.

• Minor customizations in the appearance of horizontal scroolbar in SQL and scripting editors.
• Fixed horizontal scroll repainting problem in SQL and scripting editors.

• Fixed table filter being removed when resizing the window.

• Fixed a few toolbar visibility issues.

• Fixed cell hints not working after optimizations introduced in 2.4.40.

• Minor bug fixes.

• Implemented some optimizations for handling large text fields in the grid.

• Minor UI improvements.

• Fixed schema refresh at startup.

• Fixed an internal parser error.
• Fixed AV in the left tree view.

• Fixed scrollbar repaint on the SQL editors.

• Added parenthesis around default values when restructuring a table.
• Thousand separator is now set to ',' regardless of the current locale.

• 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.

• 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.

• Fixed a parsing error.

• Improved response time when attempting to stop a long running query.
• Added "Execute SQL" button.

• Fixed a data refresh issue when creating a new table.
• Fixed resync issue when editing data in the grid.

• Fixed data refresh at startup.

• Fixed a scrollbar error.

• A few minor UI fixes.

• Added record editor.

• Fixed an error in the internal parser.

• 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.

• Fixed another metadata refresh error in query builder.

• Fixed a metadata refresh error in query builder.
• Improved error handling while refreshing schema.

• Fixed a bug in image editor.

• Improved cell hint behavior.
• Fixed a bug in grid editing.

• Modified CSV import to ignore constraint violations during the import process.

• Fixed 'no such column' error when navigating to a different table after applying a filter to the current table.

• Improved error handling when importing CSV files.

• Recompiled System.Data.SQLite with sqlite library 3.23.1.

• Fixed bug in generate HTML report.

• Fixed bug causing slow application startup.

• 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

• Fixed bug causing the export menu items to be disabled when the current grid was not focused.

• Added find dialog on the Schema and Scripting tabs.

• Filtered out system tables on the DDL tab.

• 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.

• Fixed an issue in Pascal scripting.

• Fixed bug preventing data refresh after tree selection has changed using the keyboard.

• Fixed an issue in Pascal scripting.

• 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.

• Fixed a few toolbar issues.

• Minor corrections to the help file.

• Fixed an error in parsing primary keys.

• 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.

• Fixed bug in copy/paste records from Excel.

• Added options for code completion.

• Added Find/Replace option in SQL/Lua/Pascal script editors.

• Minor internal fixes.

• Added experimental code completion.

• Fixed bug in retrieving schema.

• Minor internal fixes.

• SQLite library 3.6.23 is now included.
• Internal library is now compiled with SQLITE_ENABLE_FTS3_PARENTHESIS defined.
• Added pragma secure_delete.

• On Windows XP, panel captions were not displayed in Query Builder. This has been fixed after upgrading of the Active Query Builder component to the latest version.

• Minor customizations to Query Builder.

• Fixed bug preventing the export of GUID fields to Excel.
• Made a few corrections to help file.

• Fixed an error in the data transfer wizard.

• Minor internal fixes.

• Fixed a few issues in the internal parser.

• Added option to associate custom file extensions with SQLite Expert.
• Added ability to generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table.

• Fixed a few issues related to GUID fields in the data transfer wizard.

• Fixed AV at startup.

• Fixed error when applying changes in Options dialog.

• Added foreign key descriptions on the Schema tab.

• Fixed a few issues related to copy/paste operations in the grid.

• A few improvements to schema refresh.

• A few improvements to the database properties tab.

• Minor internal fixes.

• Fixed field reordering issue introduced in the previous version.

• Improved internal transaction handling in the presence of triggers that may rollback the current transaction.

• Fixed error in editing or adding unnamed foreign key.

• Improved error handling at startup when attempting to load a missing SQLite extension.

• Fixed bug introduced in 2.3.30 affecting the number of records displayed in the grid when record count option was set to 'Never'.

• Fixed 'rowid not found' when exporting data to SQL script.

• Modified default memory usage to 1 MB when displaying results as text.
• Fixed performance bottleneck for large queries when displaying results as text.
• Added progress indicator for displaying results as text.

• Added option to limit the amount of memory used when displaying results as text. Default is 10 MB.
• Added toolbar button that toggles between displaying results in the grid or as text.

• Added option to display the "rowid" on the Data tab.
• Added auto-refresh option for Data tab.

• Reopen databases menu item now displays databases in reverse order.
• Modified export to make sure the generated spreadsheet names are accepted by Excel.
• Attempting to close the application will display a warning if a table or a view is being edited.
• The Options dialog now remembers the last displayed page.
• Corrected background color on the About window.
• Fixed parsing error in comments containing semicolons.

• Import and export to and from CSV files now differentiate between null and empty values.
• On the text export window, changing delimiter will change the file extension.
• Modified foreign key editor to allow self-referencing foreign keys.

• Fixed program hangup when attempting to add a duplicate column after program was launched with a command line parameter.

• Added Extensions tab.
• Fixed error when attempting to add a unique constraints to a table containing more than 64 columns.

• Fixed bug preventing the posting of text fields with no declared size when editing data in the grid.

• Fixed 'no open transaction' error that might occur when refreshing schema after restructuring a table referenced by a view or a foreign key.

• A few more internal bug fixes.

• Fixed a few errors in filtering data in the grid.

• Fixed 'Index out of range' when running a CREATE TRIGGER statement.
• Fixed cascading error when selecting a view referencing a table that has been deleted.
• SQLite library 3.6.22 is now included.

• Fixed disabled 'Add' button when creating new table and selected object is not a table.

• Fixed EXPLAIN statement not displaying any columns in the grid.
• SQLite library 3.6.21 is now included.

• Fixed variant conversion error introduced in 2.3.16.

• Restructuring a table that is referenced in foreign key constraints is now enabled if no active transactions.
• Fixed 'fullfsync' pragma spelling error on the Database tab.
• Disabled field delete for fields referenced in foreign key constraints.

• Disabled field rename for fields referenced in foreign key constraints.
• Fixed bug causing the deletion of a foreign key when renaming a field included in the child key.

• Fixed syntax error when editing unique index.

• Disabled double click on Fields grid if the table cannot be modified.
• Fixed bug preventing the deletion of constraints when restructuring a table.
• Fixed slow locate of the previously selected record after refreshing a dataset.
• Fixed record count not updated after refresh.

• SQL scripts are now saved using UTF-8 encoding if necessary.

• Fixed program crash when opening SQL history containing large SQL statements.
• After aborting a time consuming query, subsequent queries were incorrectly reported as aborted. This has been corrected.

• Fixed 'Bitmap image is not valid' when generating HTML reports containing images in formats other than BMP.
• Fixed parsing error affecting grid filter using 'LIKE' expressions.

• Reduced locking errors that may occur when accessing the database from an external program while having it open in SQLite Expert. All open tables are now unlocked after one second from the last access.

• Fixed 'Dataset not in edit or insert mode' that may occur when refreshing schema.

• Rolled back optimizations implemented in 2.3.4. as they were causing 'Database is locked' error.

• Fixed 'Database is locked' error when attempting to delete a table.

• Fixed OLE error when exporting a view to Excel.

• Implemented a few internal optimizations for navigating datasets with large number of records.

• Fixed convert error when filtering on date/time columns.

• A few minor internal fixes.

• Added collation_list to the list of pragma properties on the Database tab.
• The PRAGMA collation_list is now used to populate collation combos in the field and index editors.
• Changed the grid filter code to use the SQLite LIKE function available for the current database. The previous code was using an internal function.

• Redesigned the Database tab to display or set pragma properties for all attached databases.
• Modified the table refresh to preserve the existing filter.

• Fixed bug in processing negative currency values when importing CSV files.
• SQLite library 3.6.20 is now included.

• Minor UI corrections.

• Fixed a minor bug in the foreign key editor.

• Added 'Reindex Table' and 'Reindex All Tables' options.
• Added support for auto extensions.

• Fixed error in updating records when editing data in the grid if key is a GUID stored as BLOB.

• Fixed error in loading text values stored using BLOB storage class.

• Restructuring a table referenced in foreign keys is now allowed if the table does not contain data.
• More updates to the help file.

• Fixed bug in data transfer for empty, not null values.
• Minor updates to the help file.

• Some restructure operations are now disabled on tables referenced by foreign keys.
• Added label displaying the number of foreign keys referencing the current table.

• Foreign keys are now exported to SQL scripts.
• Fixed bug in SQL parser.

• Tables are now reordered by dependencies when importing or deleting, for preventing foreign key constraint violations.

• This is a beta version with foreign key support.
• SQLite library 3.6.19 is now included.

• Updated definition of site license in the license agreement.

• A few cosmetic UI fixes.

• Fixed Cut and Paste issues when editing data in the grid.

• Fixed SHIFT-INSERT paste shortcut not working as expected when editing data in the grid.

• Fixed an issue in the behavior of the horizontal scrollbars in the grids.

• Added thumb tracking option for grid scrollbars.

• Fixed error in Query Builder preventing the default settings from being applied when creating a new join.

• Fixed AV that may occur when closing application if any registered database is not connected.

• Fixed popup menu shortcut interfering with pasting data in the grid.

• Fixed incorrect update of CHAR fields when encoding is set to "Default ANSi code page".

• Added options to set the selected cells to NULL or to a specific value.
• Upgraded some third party components to their latest versions.

• A few more internal fixes in the Query Builder.

• Fixed a repainting issue in the Query Builder.

• Fixed access violation that might occur at program shutdown when Query Builder is the active page.

• Minor usability improvements.

• Fixed "index out of range" error occurring when attempting to copy to clipboard more than 256 records at a time.

• Updated help file with the latest features.
• Minor user interface changes.

• 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.

• Added support for loaded extensions.

• 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.

• Fixed "Could not convert variant of type (Array Byte) into type (Integer)".

• Fixed incorrect update of DATE and TIME fields when the default ANSI code page is selected.

• Fixed error preventing the opening of attached databases at startup.

• Added experimental support for parameters in SQL statements.
• Added support for images imported from Access prefixed with an OLE header.
• Replaced main application icon.

• Attached databases were not restored after changing options. This has been fixed.
• ALT-F4 shortcut was not closing the application. This has been fixed.

• Enabled multiple selection for Empty Table function.
• Fixed conflict between main menu shortcuts and typing extended ASCII characters using ALT codes.

• Enabled multiple selection on tables and views for drag-drop, copy-paste and delete operations.
• Fixed a few conflicting menu shortcuts.

• 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.

• Disabled Paste from clipboard into read-only datasets.

• Added ability to Copy/Paste data, fields, indexes, constraints and triggers using the clipboard.

• 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.

• Fixed error occurring when filtering a dataset with duplicate field names.

• Added prompt for encoding when opening an empty database (having a file size of 0).

• SQLite library 3.6.16 is now included.

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

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

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

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

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

• Added support for displaying GIF images in grids.

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

• A few minor internal fixes.

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

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

• A few minor internal fixes.

• A few minor internal fixes.

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

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

• Fixed an error in the image format detection routines.

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

• 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.

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

• A few cosmetic changes to the index designer.

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

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

• Fixed an error in record filter.

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

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

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

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

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

• Minor corrections to the data transfer wizard.

• Fixed an error in exporting to SQL script.

• 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.

• Added a few improvements to the error reporting.

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

• Fixed an error in UpgradeLicense.

• 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.

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

• SQLite library version 3.6.13 is now included.

• Fixed two errors in the HTML report generation.

• 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.

• 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.

• SQLite library 3.6.12 is now included.

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

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

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

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

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

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

• 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.

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

• Fixed a few errors in HTML report generation.

• Fixed a minor parser error.

• Fixed a few minor issues in field editing.

• 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.

• Fixed syntax error occurring when filtering views.

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

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

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

• 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.

• Fixed tab behavior on script editor windows.

• Fixed button alignment on the text export form.

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

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

• SQLite library 3.6.7 included.
• Minor internal fixes.

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

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

• Improved performance for import from CSV files.

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

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

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

• SQLite library 3.6.6.2 is now included.

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

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

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

• Fixed a few button alignment issues.

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

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

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

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

• Null values are now displayed as <null>.

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

• 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.

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

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

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

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

• 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.

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

• 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.

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

• 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.

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

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

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

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

• 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.

• 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.

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

• 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.

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

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

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

• 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.

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

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

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

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

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

• 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.

• Added a few improvements to the Data Transfer Wizard.

• 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.

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

• 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.

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

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

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

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

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

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

• SQLite3.dll version 3.6.1 is now included.

• 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.

• Performance improvements for executing Lua and Pascal scripts.

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

• 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.

• 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.

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

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

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

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

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

• 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.

• Improved integrity check results dialog.

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

• Fixed internal error preventing the update of BLOB fields.

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

• Fixed error in updating date and time fields.

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

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

• Fixed parsing error when processing unnamed constraints.

• Improved collation handling when restructuring a table.

• Minor user interface changes.

• 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.

• Fixed access violation when creating a new table.

• Fixed bug in table restructuring introduced in version 1.6.61.

• 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.

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

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

• Minor user interface changes.

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

• 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.

• Minor user interface improvements.

• Minor user interface improvements.

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

• Fixed error in trigger editor.

• Fixed another error in parsing triggers.

• Fixed a few errors in parsing triggers.

• Fixed error applying changes after editing a view.

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

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

• Fixed duplicate application icon on taskbar.

• 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.

• Fixed an internal SQL parser error.

• Fixed a few errors in trigger editing.

• 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.

• Fixed minor error in index editing.

• Volume discounts and site licenses are now available.

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

• 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.

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

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

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

• Minor internal bug fixes.

• 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.

• 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.

• Minor user interface fixes.

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

• Minor user interface fixes.

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

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

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

• 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.

• Indexes are now sorted alphabetically.

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

• Minor GUI improvements.

• 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.

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

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

• 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.

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

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

• Fixed internal error in exception handling.

• 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.

• 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.

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

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

• Fixed internal errors in executing SQL queries containing comments.

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

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

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

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

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

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

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

• 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.

• 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.

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

• 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.

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

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

• Minor corrections in the help file.

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

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

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

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

Revision History

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

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

• Minor bug fixes.

• Improved error handling when refreshing database schema.

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

• Fixed refresh problem in SQL window.

• 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.

• Minor bug fixes.
• SQLite library 3.4.0 included.

• 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.

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

• 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.

• Fixed access violation when changing settings.

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

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

• Fixed several bugs in the field editor.

• 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.

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

• Minor internal changes.

• Fixed access violation on refresh data.

• Minor internal changes.

• Minor internal changes.

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

• Fixed grid refresh error on SQL tab.

• Minor internal changes.

• 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.

• Improved error handling during startup.

• Minor bug fixes.

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

• 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.

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

• 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.

• 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.

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

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

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

• 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.

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

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

• 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.

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

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

• 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.

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

• Grid column widths now adjust dynamically to text length.

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

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

• 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.

• Fixed bug in date and time format.

• Other internal bug fixes.

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

• 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.

• 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.

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

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

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

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

• 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.

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

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

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

• 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.

• 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.

• 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.