New in version 3.5.49.2469

June 2nd, 2014
  • Added support for partial indexes.
  • Added support for tables without rowid.

New in version 3.5.6.2425 (December 10th, 2013)

  • Improved license registration process.

New in version 3.4.98.2328 (November 4th, 2013)

  • Upgraded ICU library to version 52

New in version 3.4.97.2327 (October 30th, 2013)

  • Removed "rowid" from the list of available parent columns on the foreign key editor.

New in version 3.4.96.2326 (October 29th, 2013)

  • Fixed error when creating a new table with indexes.

New in version 3.4.95.2325 (October 28th, 2013)

  • Fixed error when creating foreign keys.

New in version 3.4.94.2324 (October 26th, 2013)

  • Fixed when applying changes after deleting an index.

New in version 3.4.93.2323 (October 26th, 2013)

  • Fixed AV when creating table in an empty database.

New in version 3.4.92.2322 (October 26th, 2013)

  • Fixed error when creating foreign keys.

New in version 3.4.91.2321 (October 25th, 2013)

  • Fixed a few issues in trigger editing using the visual editor.

New in version 3.4.90.2320 (October 24th, 2013)

  • Fixed keyword capitalization in queries generated with the Query Builder.
  • Fixed error when renaming a table.
  • Fixed error when copying a table using drag and drop.

New in version 3.4.89.2319 (October 23rd, 2013)

  • Fixed a bug in query builder generating incorrect queries for tables in attached databases

New in version 3.4.88.2318 (October 23rd, 2013)

  • Fixed a bug preventing queries using table aliases from being editable

New in version 3.4.87.2317 (October 22nd, 2013)

  • SQLite library 3.8.1 included.
  • Table names are now always qualified.
  • Fixed a few issues related to temporary triggers.

New in version 3.4.86.2316 (October 18th, 2013)

  • Modified database creation dialog to allow providing the encryption key, for compatibility with SQLCipher

New in version 3.4.84.2314 (October 15th, 2013)

  • Fixed errors in handling in memory and attached databases

New in version 3.4.83.2313 (October 12th, 2013)

  • Fixed an error in restructuring tables in temporary or attached databases.

New in version 3.4.82.2312 (October 10th, 2013)

  • Fixed an error in generating filter expression

New in version 3.4.81.2311 (October 7th, 2013)

  • Fixed an error in generating DDL for columns having declared sizes.

New in version 3.4.80.2310 (October 2nd, 2013)

  • Fixed order of records when pasting data from Excel.

New in version 3.4.79.2309 (October 1st, 2013)

  • Fixed detection of delimiter when pasting data from Excel

New in version 3.4.78.2308 (September 23rd, 2013)

  • SQLite library 3.8.0.2 included.

New in version 3.4.77.2307 (September 7th, 2013)

  • Enhanced the Pascal Script query object by adding a Fields function to allow iteration of the query fields by index

New in version 3.4.76.2306 (August 28th, 2013)

  • SQLite library 3.8 included.

New in version 3.4.75.2305 (August 28th, 2013)

  • Fixed alternate row color not persisted between sessions.

New in version 3.4.74.2304 (July 28th, 2013)

  • Fixed tree refresh issue after renaming a table

New in version 3.4.73.2303 (July 22nd, 2013)

  • Fixed incorrect copy/paste of numeric values on systems having the decimal separator different than '.'

New in version 3.4.72.2302 (July 22nd, 2013)

  • Fixed incorrect handling of boolean data types

New in version 3.4.71.2301 (July 18th, 2013)

  • Fixed error preventing the usage of null values in parameterized queries.
  • Fixed error preventing the usage of empty table names or field names which are valid in SQLite.

New in version 3.4.70.2300 (June 8th, 2013)

  • Fixed a few more skin color issues.

New in version 3.4.69.2299 (June 4th, 2013)

  • Fixed a few skin color issues

New in version 3.4.68.2298 (June 4th, 2013)

  • Fixed a few skin color issues

New in version 3.4.67.2297 (May 31st, 2013)

  • Rolled back changes in the previous version.

New in version 3.4.66.2296 (May 31st, 2013)

  • Fixed an error executing SQL queries containing sub-queries.

New in version 3.4.65.2295 (May 30th, 2013)

  • Fixed error in importing large UTF-8 encoded CSV files

New in version 3.4.64.2294 (May 27th, 2013)

  • Removed wal_checkpoint added by mistake to the list of pragma properties.

New in version 3.4.63.2293 (May 23rd, 2013)

  • SQLite library version 3.7.16.2 is now included.
  • Added support for pragma application_id, busy_timeout, mmap_size, vdbe_addoptrace, wal_checkpoint.
  • The first five lines of the SQL statement that caused an error are now included in the error message.

New in version 3.4.62.2292 (May 20th, 2013)

  • Fixed issue in generating table creation SQL when declared type is not a valid identifier.

New in version 3.4.61.2291 (April 30th, 2013)

  • Fixed character encoding issue in Lua scripting engine.

New in version 3.4.60.2287 (April 25th, 2013)

  • Fixed bug in restoring windows position when using multiple monitors.

New in version 3.4.59.2289 (April 18th, 2013)

  • SQLite library version 3.7.16.2 is now included.
  • Modified random data generation to take into account the declared types, e.g. for type BYTE the range will be 0 to 255.
  • Fixed index out of range error when inserting a large number of records using the clipboard.

New in version 3.4.58.2286 (April 12th, 2013)

  • Added tab indent option for all editors.

New in version 3.4.57.2285 (April 5th, 2013)

  • Fixed a bug in the SQL parser.

New in version 3.4.56.2284 (April 1st, 2013)

  • SQLite library version 3.7.16.1 is now included.

New in version 3.4.55.2283 (March 28th, 2013)

  • Fixed another query builder refresh issue.

New in version 3.4.54.2282 (March 27th, 2013)

  • Fixed query builder refresh issue

New in version 3.4.53.2281 (March 21st, 2013)

  • SQLite library version 3.7.16 is now included.
  • Fixed bug in refreshing database properties.

New in version 3.4.52.2280 (March 18th, 2013)

  • Fixed word wraping bug causing the program to hang at startup.

New in version 3.4.51.2279 (February 25th, 2013)

  • Fixed incorrect word wrapping in SQL editor when max line width exceeds 255 characters.

New in version 3.4.50.2278 (February 11th, 2013)

  • Fixed a bug handling default values.

New in version 3.4.49.2277 (January 31st, 2013)

  • Fixed a bug in parsing primary key.

New in version 3.4.48.2275 (January 22nd, 2013)

  • Fixed bug in applying SQL editor font color when using themes.
  • Updated SQLite library to 3.7.15.2.

New in version 3.4.47.2269 (December 8th, 2012)

  • Minor user interface improvements.

New in version 3.4.46.2268 (December 5th, 2012)

  • SQLite library is now compiled with SQLITE_ENABLE_FTS4_UNICODE61.

New in version 3.4.45.2267 (December 3rd, 2012)

  • Pragma 'default_cache_size' is no longer used.

New in version 3.4.44.2266 (December 3rd, 2012)

  • Fixed 'database is locked' error when refreshing database properties while using exclusive locking.

New in version 3.4.43.2265 (November 29th, 2012)

  • Updated pragma list on database tab.

New in version 3.4.42.2264 (November 27th, 2012)

  • Fixed error parsing primary key conflict clause.

New in version 3.4.41.2263 (November 27th, 2012)

  • Fixed encoding issue when importing data from text files

New in version 3.4.39.2261 (November 21st, 2012)

  • Fixed bug in handling null values when importing data from CSV files.

New in version 3.4.37.2259 (November 14th, 2012)

  • Query Builder layout is no longer cleared when an error occurs during SQL generation.

New in version 3.4.36.2258 (November 6th, 2012)

  • Fixed encoding issue when copying data to clipboard.

New in version 3.4.35.2257 (October 31st, 2012)

  • Fixed bug in character encoding detection when pasting data from Excel

New in version 3.4.34.2256 (October 16th, 2012)

  • Fixed startup error on Windows 2000.

New in version 3.4.33.2255 (October 8th, 2012)

  • SQLite library 3.7.14.1 included.

New in version 3.4.32.2254 (September 27th, 2012)

  • Fixed encoding issue when copying data to clipboard

New in version 3.4.31.2253 (September 19th, 2012)

  • Fixed bug in importing text files when the destination table name needs quoting.

New in version 3.4.30.2252 (September 19th, 2012)

  • Fixed bug in character encoding detection when loading text files

New in version 3.4.29.2251 (September 18th, 2012)

  • Fixed an error in internal SQL parser

New in version 3.4.28.2250 (September 17th, 2012)

  • Improved character encoding detection when loading text files with missing BOM.

New in version 3.4.27.2249 (September 13th, 2012)

  • A warning is now displayed if the maximum cell length has been exceeded when exporting to Excel.

New in version 3.4.26.2248 (September 10th, 2012)

  • Data transfer operations now handle circular foreign key references correctly.
  • SQLite library 3.7.14 included.

New in version 3.4.25.2247 (August 27th, 2012)

  • Fixed bug in ordering objects by dependencies when exporting to SQL script.

New in version 3.4.24.2246 (August 20th, 2012)

  • Improved the timing of queries having unbound parameters.

New in version 3.4.23.2245 (August 20th, 2012)

  • Fixed a bug in foreign key parsing

New in version 3.4.22.2244 (August 20th, 2012)

  • Minor DATE/DATETIME fixes.

New in version 3.4.21.2243 (July 27th, 2012)

  • Fixed bug in filtering DATE/DATETIME fields.

New in version 3.4.20.2242 (July 16th, 2012)

  • Fixed bug preventing the editing of long lines in SQL editor.

New in version 3.4.19.2241 (July 2nd, 2012)

  • Fixed skin support on the main toolbar.

New in version 3.4.18.2240 (June 30th, 2012)

  • Added Ctrl+Enter shortcut for record editor.

New in version 3.3.55 Build 2206 (January 16th, 2012)

  • Fixed an issue in restructuring tables having default values.

New in version 3.3.54 Build 2205 (January 16th, 2012)

  • Fixed issue with F3 shortcut key in search/replace dialog

New in version 3.3.53 Build 2204 (January 16th, 2012)

  • Fixed case sensitivity issue in search/replace dialog

New in version 3.3.52 Build 2203 (January 16th, 2012)

  • Modified error reporting options to include only basic debug information

New in version 3.3.51 Build 2202 (January 16th, 2012)

  • Fixed bug causing the locking of the database file after an unsuccessful attempt to open an encrypted database

New in version 3.3.50 Build 2201 (January 16th, 2012)

  • Fixed text clipping issues in data transfer wizard when using large fonts.
  • Fixed bug in grid filter on GUID fields.
  • SQLite library 3.7.9 included.

New in version 3.3.49 Build 2200 (January 16th, 2012)

  • Minor user experience improvements.
  • License upgrade tool no longer included.

New in version 3.3.48 Build 2199 (January 16th, 2012)

  • Fixed a bug in retrieving the SQLite error message

New in version 3.3.47 Build 2198 (January 16th, 2012)

  • Fixed bug in exporting GUID values to CSV

New in version 3.3.46 Build 2196 (January 16th, 2012)

  • Checking for updates now allows downloading and installing new version from within the program

New in version 3.3.45 Build 2195 (January 16th, 2012)

  • Fixed incorrect ordering on Database tab

New in version 3.3.44 Build 2194 (October 10th, 2011)

  • Fixed bug on extensions tab - functions and collations displayed for the wrong extension.

New in version 3.3.42 Build 2192 (September 24th, 2011)

  • DOCID is now preserved when restructuring virtual table.

New in version 3.3.33 Build 2174 (August 8th, 2011)

  • Minor internal fixes.

New in version 3.3.30 Build 2166 (July 15th, 2011)

  • Updated help file.

New in version 3.3.27 Build 2157 (May 21st, 2011)

  • SQLite library 3.7.6.3 is now included.

New in version 3.3.26 Build 2156 (May 21st, 2011)

  • Fixed bug causing incorrect order of fields in an index.

New in version 3.3.25 Build 2155 (May 21st, 2011)

  • Fixed startup error message when using external library.
  • Fixed "table not found" error when creating an index on a new table.

New in version 3.3.24 Build 2154 (May 9th, 2011)

  • The 'move up' and 'move down' buttons now work with multiple selected records on the field designer.

New in version 3.3.23 Build 2153 (May 9th, 2011)

  • Fixed bug in index editor.

New in version 3.3.22 Build 2152 (May 9th, 2011)

  • Improved JPEG image format detection.

New in version 3.3.21 Build 2151 (May 9th, 2011)

  • The record counts are now calculated using separate connections to the database.

New in version 3.3.20 Build 2150 (April 22nd, 2011)

  • The record count feature is now optional.

New in version 3.3.19 Build 2149 (April 21st, 2011)

  • The record count feature is now disabled to prevent performance issues on large databases. It will be made optional in the next version.

New in version 3.3.17 Build 2147 (April 18th, 2011)

  • SQLite library 3.7.6.2 is now included.

New in version 3.3.16 Build 2146 (April 18th, 2011)

  • Fixed field not found error when primary key field contains blank characters.

New in version 3.3.15 Build 2145 (April 16th, 2011)

  • Record count is now always displayed for all tables and views.
  • SQLite library 3.7.6.1 is now included.

New in version 3.3.14 Build 2144 (April 16th, 2011)

  • Fixed AV after opening and canceling the Options window.

New in version 3.3.13 Build 2143 (April 16th, 2011)

  • Fixed error in refreshing schema after deleting an object.

New in version 3.3.12 Build 2142 (April 16th, 2011)

  • Fixed error in sorting objects by dependencies when exporting data.
  • Fixed error in generating SQL for tables having foreign keys.

New in version 3.3.11 Build 2141 (April 16th, 2011)

  • SQLite library 3.7.6 is now included.

New in version 3.3.10 Build 2140 (April 16th, 2011)

  • Fixed program startup error when using auto-extensions.

New in version 3.3.9 Build 2139 (April 16th, 2011)

  • Added support for the ICU extension.

New in version 3.3.8 Build 2138 (April 16th, 2011)

  • Fixed bug in refreshing data when being displayed in text mode.

New in version 3.3.7 Build 2137 (April 16th, 2011)

  • Fixed bug in importing null values from CSV files.

New in version 3.3.6 Build 2136 (April 16th, 2011)

  • Added database online backup option.

New in version 3.3.3 Build 2133 (March 28th, 2011)

  • Added database DDL compare tool.

New in version 3.3.2 Build 2132 (March 21st, 2011)

  • Added options "Auto cell height" and "Show cell hints" to main menu.

New in version 3.3.1 Build 2131 (March 21st, 2011)

  • Added support for RTREE virtual tables.

New in version 3.3.0 Build 2130 (March 18th, 2011)

  • Added support for virtual tables including FTS3 and FTS4.
  • Added progress bar, cancel button and improved performance when generating random data.

New in version 3.2.22 Build 2122 (March 18th, 2011)

  • Added option "Execute SQL (current statement)".

New in version 3.2.21 Build 2121 (March 18th, 2011)

  • Fixed a bug in refreshing schema.

New in version 3.2.20 Build 2120 (March 18th, 2011)

  • Fixed a bug in the internal parser.

New in version 3.2.19 Build 2119 (March 18th, 2011)

  • Improved tabbed navigation on the record editor.

New in version 3.2.18 Build 2118 (March 18th, 2011)

  • Modified internal handling of blob fields for accurate display in the Hex editor regardless of the storage class.

New in version 3.2.17 Build 2117 (March 18th, 2011)

  • Fixed bug introduced in previous version preventing the usage of external SQLite libraries.

New in version 3.2.16 Build 2116 (March 18th, 2011)

  • Added support for changing the field sort order in the index editor.

New in version 3.2.15 Build 2115 (February 7th, 2011)

  • Fixed datetime display error occurring for date values above year 2100.

New in version 3.2.13 Build 2113 (February 2nd, 2011)

  • Fixed a registry error when reading file associations

New in version 3.2.12 Build 2112 (January 21st, 2011)

  • Fixed error in copy/paste records on systems with decimal separator different than ".".

New in version 3.2.11 Build 2111 (January 19th, 2011)

  • Fixed incorrect application title in Professional Edition.

New in version 3.2.10 Build 2110 (January 8th, 2011)

  • Upgraded external SQLite library to 3.7.4.

New in version 3.2.9 Build 2109 (January 7th, 2011)

  • Minor UI fixes.

New in version 3.2.8 Build 2108 (January 5th, 2011)

  • Added associated extensions to the list of file extensions in the open database dialogs.

New in version 3.2.7 Build 2107 (January 5th, 2011)

  • Performance improvements for datasets with a large number of columns.

New in version 3.2.6 Build 2106 (December 17th, 2010)

  • SQLite library version 3.7.4 is now included.
  • Added option to set a default encryption key.
  • Minor internal fixes.

New in version 3.2.5 Build 2105 (November 16th, 2010)

  • Improved image format detection for images displayed in the grid.

New in version 3.2.4 Build 2104 (November 15th, 2010)

  • Grid selection is now cleared after sorting by a column.

New in version 3.2.3 Build 2103 (November 15th, 2010)

  • Fixed cell auto height not using the current setting on a new SQL tab.

New in version 3.2.2 Build 2102 (November 12th, 2010)

  • Minor corrections to the Pascal script engine.

New in version 3.2.1 Build 2101 (November 11th, 2010)

  • Added "Close other SQL tabs" menu item.
  • Updated sample scripts to work with version 3.
  • Fixed an error in Lua script output.
  • Fixed a database locking error.

New in version 3.2.0 Build 2100 (November 11th, 2010)

  • Added database repair function.
  • Added pragmas automatic_index and wal_autocheckpoint.
  • Fixed error updating data after modifying in Hex editor.

New in version 3.1.23 Build 2099 (November 11th, 2010)

  • Fixed error in local time calculation when using the internal SQLite library.

New in version 3.1.22 Build 2098 (October 10th, 2010)

  • Added rowid to the parent key drop-down list in the foreign key editor.

New in version 3.1.21 Build 2097 (October 9th, 2010)

  • SQLite library version 3.7.3 included.

New in version 3.1.20 Build 2096 (October 8th, 2010)

  • Fixed bug in import from a text file with encoding set to "Default ANSI code page" on multi byte character sets.

New in version 3.1.19 Build 2095 (October 7th, 2010)

  • Fixed error in refreshing non-integer primary key for tables having unique constraints".

New in version 3.1.18 Build 2094 (October 6th, 2010)

  • Fixed bug in import from a text file with encoding set to "Default ANSI code page".

New in version 3.1.17 Build 2093 (October 2nd, 2010)

  • Fixed error in local time calculation when using the internal SQLite library.

New in version 3.1.16 Build 2092 (October 1st, 2010)

  • Fixed SQLite library not restored at application startup.

New in version 3.1.15 Build 2091 (September 29th, 2010)

  • Fixed bug in restoring SQL history at application startup.

New in version 3.1.14 Build 2090 (September 27th, 2010)

  • Implemented some schema refresh optimizations.

New in version 3.1.13 Build 2089 (September 27th, 2010)

  • Fixed error in local time calculation when using internal lSQLite library.

New in version 3.1.12 Build 2088 (September 27th, 2010)

  • Added tab width option.
  • Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.

New in version 3.1.11 Build 2087 (September 14th, 2010)

  • Added option to open multiple SQL tabs.

New in version 3.1.10 Build 2086 (September 10th, 2010)

  • Fixed incorrect restoring of SQL queries containing double quotes at program startup.
  • Internal SQLite library now supports encryption (Professional Edition).

New in version 3.1.9 Build 2085 (September 2nd, 2010)

  • Added word-wrap option for SQL editors.

New in version 3.1.8 Build 2084 (September 2nd, 2010)

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

New in version 3.1.7 Build 2083 (September 1st, 2010)

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

New in version 3.1.6 Build 2082 (September 1st, 2010)

  • Fixed current record number not being displayed except the first SQL tab.
  • Fixed conversion error when applying a filter on a field containing null records.

New in version 3.1.5 Build 2081 (August 25th, 2010)

  • SQLite library 3.7.2 included.

New in version 3.1.4 Build 2080 (August 23rd, 2010)

  • Fixed navigator buttons not working on the SQL tabs.

New in version 3.1.3 Build 2079 (August 23rd, 2010)

  • Fixed record number not showing on the SQL grids.

New in version 3.1.2 Build 2078 (August 23rd, 2010)

  • SQLite library 3.7.1 included.

New in version 3.1.1 Build 2077 (August 23rd, 2010)

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

New in version 3.1.0 Build 2076 (August 23rd, 2010)

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

New in version 3.0.40 Build 2075 (August 20th, 2010)

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

New in version 3.0.39 Build 2074 (August 7th, 2010)

  • SQLite library 3.7.0.1 included.

New in version 3.0.38 Build 2073 (August 7th, 2010)

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

New in version 3.0.37 Build 2072 (August 7th, 2010)

  • The progress bar and the cancel button are now working when importing an SQL script.
  • Fixed out of memory error when importing very large SQL scripts.

New in version 3.0.36 Build 2071 (August 7th, 2010)

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

New in version 3.0.35 Build 2070 (August 2nd, 2010)

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

New in version 3.0.34 Build 2069 (August 2nd, 2010)

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

New in version 3.0.33 Build 2068 (July 29th, 2010)

  • Added skin library.
  • Added printing library.
  • Added support for custom delimiters when exporting/importing to/from text files.
  • Added option to allow only one instance of the application.
  • Grid rows now resize height with the size of the text.

New in version 2.4.46 Build 2027 (May 27th, 2010)

  • Fixed bug in handling savepoints with duplicate names.

New in version 2.4.45 Build 2026 (May 18th, 2010)

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

New in version 2.4.44 Build 2025 (May 13th, 2010)

  • Fixed table filter being removed when resizing the window.

New in version 2.4.43 Build 2024 (May 13th, 2010)

  • Fixed a few toolbar visibility issues

New in version 2.4.42 Build 2022 (May 12th, 2010)

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

New in version 2.4.41 Build 2021 (May 12th, 2010)

  • Minor bug fixes.

New in version 2.4.40 Build 2020 (May 12th, 2010)

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

New in version 2.4.39 Build 2019 (May 10th, 2010)

  • Minor UI improvements.

New in version 2.4.37 Build 2017 (May 10th, 2010)

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

New in version 2.4.34 Build 2014 (May 10th, 2010)

  • Replaced some of the toolbar icons.
  • Fixed grid refresh error when two or more columns are filtered.
  • Fixed a parsing error causing incorrect display of foreign key constraints.

New in version 2.4.31 Build 2011 (May 10th, 2010)

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

New in version 2.4.25 Build 2005 (May 10th, 2010)

  • In the image editor, dbl-click on the image will maximize or restore the window.
  • RowID is now added to non-editable SELECT queries, so in most cases they become editable.
  • Removed some redundant refresh operations.
  • Fixed error when executing Pascal scripts in encrypted databases.

New in version 2.4.21 Build 2001 (May 10th, 2010)

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

New in version 2.4.14 Build 1994 (May 10th, 2010)

  • To avoid any confusion, export menu items have been removed from the tree popup menu and from the main menu. Export options apply to the selected grid, so they will only be available in the grid popup menus

New in version 2.4.10 Build 1990 (May 10th, 2010)

  • When a database is selected, the DDL tab now shows the whole create script for the database.
  • In data transfer operations, the objects are now copied in the order of dependencies.
  • SQLite library 3.6.23.1 is now included.

New in version 2.4.6 Build 1986 (May 10th, 2010)

  • The Show/Hide features is now the first tab in Tools/Options.
  • Fixed a startup bug when launching the application with an encrypted database in the command line.
  • Upgraded some components.
  • In Options, renamed fonts to 'Application Font' and 'SQL Editor Font'.
  • Some minor UI fixes.

New in version 2.4.2 Build 1982 (May 10th, 2010)

  • Added option to hide tabs and menu items to prevent bloating the user interface.
  • Fixed a parser error in foreign keys.
  • Implemented workaround for determining the setting of case_sensitive_like pragma.
  • Fixed concatenation operator || not being recognized by SQL Builder.

New in version 2.4.0 Build 1980 (May 10th, 2010)

  • Added options for code completion.

New in version 2.3.56 Build 1974 (May 10th, 2010)

  • Added experimental code completion.

New in version 2.2.9 Build 1910 (November 2nd, 2009)

  • Fixed a minor bug in the foreign key editor.

New in version 2.2.8 Build 1909 (October 30th, 2009)

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

New in version 2.2.7 Build 1908 (October 27th, 2009)

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

New in version 2.2.6 Build 1907 (October 27th, 2009)

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

New in version 2.2.5 Build 1906 (October 27th, 2009)

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

New in version 2.2.4 Build 1905 (October 27th, 2009)

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

New in version 2.2.3 Build 1904 (October 27th, 2009)

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

New in version 2.2.2 Build 1903 Beta (October 27th, 2009)

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

New in version 2.2.1 Build 1902 Beta (October 27th, 2009)

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

New in version 2.2.0 Build 1901 Beta (October 27th, 2009)

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

New in version 2.1.27 Build 1896 (October 27th, 2009)

  • Updated definition of site license in the license agreement.

New in version 2.1.26 Build 1895 (October 27th, 2009)

  • A few cosmetic UI fixes. .

New in version 2.1.25 Build 1894 (October 27th, 2009)

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

New in version 2.1.24 Build 1893 (October 27th, 2009)

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

New in version 2.1.23 Build 1892 (October 27th, 2009)

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

New in version 2.1.22 Build 1891 (October 27th, 2009)

  • Added thumb tracking option for grid scrollbars.

New in version 2.1.21 Build 1890 (October 27th, 2009)

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

New in version 2.1.20. Build 1889 (October 27th, 2009)

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

New in version 2.1.19. Build 1888 (October 27th, 2009)

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

New in version 2.1.18. Build 1887 (October 27th, 2009)

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

New in version 2.1.27 Build 1896 (October 15th, 2009)

  • Updated definition of site license in the license agreement.

New in version 2.1.26 Build 1895 (October 12th, 2009)

  • A few cosmetic UI fixes.

New in version 2.1.25 Build 1894 (October 12th, 2009)

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

New in version 2.1.24 Build 1893 (October 2nd, 2009)

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

New in version 2.1.23 Build 1892 (October 1st, 2009)

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

New in version 2.1.22 Build 1891 (September 30th, 2009)

  • Added thumb tracking option for grid scrollbars.

New in version 2.1.21 Build 1890 (September 29th, 2009)

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

New in version 2.1.20 Build 1889 (September 29th, 2009)

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

New in version 2.1.19 Build 1888 (September 28th, 2009)

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

New in version 2.1.18 Build 1887 (September 28th, 2009)

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

New in version 2.1.17 Build 1886 (September 23rd, 2009)

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

New in version 2.1.16 Build 1885 (September 21st, 2009)

  • A few more internal fixes in the Query Builder.

New in version 2.1.15 Build 1884 (September 20th, 2009)

  • Fixed a repainting issue on Query Builder.

New in version 2.1.14 Build 1883 (September 20th, 2009)

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

New in version 2.1.13 Build 1882 (September 19th, 2009)

  • Minor usability improvements.

New in version 2.1.12 Build 1881 (September 17th, 2009)

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

New in version 2.1.11 Build 1879 (September 16th, 2009)

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

New in version 2.1.10 Build 1878 (September 16th, 2009)

  • Fixed bug that may cause loss of data when restructuring tables with no primary key. Upgrade from versions 2.1.8 and 2.1.9 is highly recommended.

New in version 2.1.9 Build 1877 (September 16th, 2009)

  • Added support for loaded extensions.

New in version 2.1.8 Build 1876 (September 14th, 2009)

  • Enabled editing triggers and constraints in Personal Edition.
  • Enabled cell select mode. Added option to switch between cell select and row select modes.
  • Modified query parameter prompt to accept string parameters not enclosed in quotes.
  • Added 'Generate random data' function.
  • Improved error handling.
  • SQLite library 3.6.18 is now included.
  • A few internal bug fixes.

New in version 2.1.7 Build 1875 (September 11th, 2009)

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

New in version 2.1.6 Build 1874 (September 10th, 2009)

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

New in version 2.1.5 Build 1873 (September 9th, 2009)

  • Fixed error preventing the opening of attached databases at startup

New in version 2.1.4 Build 1872 (September 8th, 2009)

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

New in version 2.1.3 Build 1871 (September 5th, 2009)

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

New in version 2.1.2 Build 1870 (September 4th, 2009)

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

New in version 2.1.1 Build 1869 (September 3rd, 2009)

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

New in version 2.1.0 Build 1865 (August 31st, 2009)

  • Added support for attached databases.
  • Added support for nested transactions.
  • Added ability to copy tables between databases using the clipboard (Professional Edition).
  • Added ability to copy tables between databases drag and drop (Professional Edition).
  • Added menu items for increasing and decreasing font size.
  • Added menu shortcuts.
  • Applying changes when restructuring a table or a view now uses a nested transaction.
  • Renamed 'Create Database' menu item to 'New Database'.
  • GUID values not enclosed in brackets are now accepted as valid.
  • Fixed a few errors in evaluation of filter expressions.
  • Updated help file with the latest features since 2.0.44.
  • SQLite library 3.6.17 is now included.
  • System.Data.SQLite library version 3.6.16 is now included.

New in version 2.0.45 Build 1863 (August 9th, 2009)

  • Disabled Paste from clipboard into read-only datasets.

New in version 2.0.44 Build 1862 (August 9th, 2009)

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

New in version 2.0.43 Build 1861 (July 27th, 2009)

  • Fixed "Invalid variant type" occurring on Windows 2000 when editing data in the grid.
  • Fixed incorrect handling of some queries as editable instead of read-only.
  • Fixed error occurring when filtering a query having an ORDER BY clause.

New in version 2.0.42 Build 1860 (July 4th, 2009)

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

New in version 2.0.41 Build 1859 (July 2nd, 2009)

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

New in version 2.0.40 Build 1858 (July 2nd, 2009)

  • SQLite library 3.6.16 is now included.

New in version 2.0.39 Build 1857 (July 2nd, 2009)

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

New in version 2.0.38 Build 1856 (June 23rd, 2009)

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

New in version 2.0.37 Build 1855 (June 19th, 2009)

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

New in version 2.0.36 Build 1854 (June 5th, 2009)

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

New in version 2.0.35 Build 1853 (June 5th, 2009)

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

New in version 2.0.34 Build 1852 (June 5th, 2009)

  • Added support for displaying GIF images in grids.

New in version 2.0.33 Build 1851 (June 5th, 2009)

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

New in version 2.0.32 Build 1850 (June 5th, 2009)

  • A few minor internal fixes.

New in version 2.0.31 Build 1849 (June 5th, 2009)

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

New in version 2.0.30 Build 1848 (June 5th, 2009)

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

New in version 2.0.29 Build 1847 (June 5th, 2009)

  • A few minor internal fixes.

New in version 2.0.28 Build 1846 (May 22nd, 2009)

  • A few minor internal fixes.

New in version 2.0.27 Build 1845 (May 22nd, 2009)

  • Internal sqlite3 library is now compiled with FTS3 enabled.
  • SQLite library version 3.6.14.1 is now included.

New in version 2.0.26 Build 1844 (May 22nd, 2009)

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

New in version 2.0.25 Build 1843 (May 22nd, 2009)

  • Fixed an error in the image format detection routines.

New in version 2.0.24 Build 1842 (May 22nd, 2009)

  • Fixed bug causing the encryption keys to be incorrectly persisted

New in version 2.0.23 Build 1841 (May 22nd, 2009)

  • Added a 10 seconds timeout when checking for a new version in order to prevent an application hang.
  • SQLite library version 3.6.14 is now included.

New in version 2.0.22 Build 1840 (May 8th, 2009)

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

New in version 2.0.21 Build 1839 (May 8th, 2009)

  • A few cosmetic changes to the index designer.

New in version 2.0.20 Build 1838 (May 8th, 2009)

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

New in version 2.0.19 Build 1837 (May 8th, 2009)

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

New in version 2.0.18 Build 1834 (May 8th, 2009)

  • Fixed an error in record filter.

New in version 2.0.17 Build 1832 (May 8th, 2009)

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

New in version 2.0.16 Build 1831 (May 8th, 2009)

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

New in version 2.0.15 Build 1830 (May 8th, 2009)

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

New in version 2.0.14 Build 1829 (May 8th, 2009)

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

New in version 2.0.13 Build 1828 (May 8th, 2009)

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

New in version 2.0.12 Build 1826 (April 24th, 2009)

  • Minor corrections to the data transfer wizard.

New in version 2.0.0 Build 1802 (April 14th, 2009)

  • Improved Unicode support.
  • More encoding options on import/export from/to text files.
  • An encoding detection when importing a text file has been included that seems to work reasonably well in most cases.
  • Statically linked sqlite library is included.
  • For more information, see "What's new in version 2.0?" in the help file.

New in version 1.7.89 Build 1790 (April 14th, 2009)

  • SQLite library 3.6.12 is now included.

New in version 1.7.87 Build 1788 (March 29th, 2009)

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

New in version 1.7.86 Build 1787 (March 15th, 2009)

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

New in version 1.7.82 Build 1783 (February 28th, 2009)

  • Enabled word-wrapping on all SQL editors.
  • Fixed error causing high CPU load when checking for new version on a computer with a firewall preventing outgoing connections.
  • Fixed error caused by F6 shortcut to a disabled function in the Personal Edition.

New in version 1.7.79 Build 1780 (February 16th, 2009)

  • Fixed a minor parser error.

New in version 1.7.78. build 1779 (February 10th, 2009)

  • Fixed a few minor issues in field editing.

New in version 1.7.75 Build 1776 (January 31st, 2009)

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

New in version 1.7.73 Build 1774 (January 17th, 2009)

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

New in version 1.7.71 Build 1772 (January 5th, 2009)

  • Fixed tab behavior on script editor windows.

New in version 1.7.68 Build 1769 (December 23rd, 2008)

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

New in version 1.7.66 Build 1767 (December 19th, 2008)

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

New in version 1.6.65 Build 1577 (May 16th, 2008)

  • Minor user interface changes.