Softpedia >Windows >Internet >Servers >Database Utils >SQLite Expert Professional >  Changelog

SQLite Expert Professional Changelog

What's new in SQLite Expert Professional 5.3.3 Build 389

Feb 25, 2019
  • Added support for UPSERT clause.

New in SQLite Expert Professional 5.2.0.178 (Sep 19, 2017)

  • Due to user feedback, we have decided to bring back the DevExpress components used in version 3.x. This fixes some issues related to displaying and editing data in the grid, and improves the overall look and feel of the application by replacing the VCL Styles with the DevExpress Skin Library.
  • Added data export to JSON.

New in SQLite Expert Professional 4.0.0.453 (Apr 22, 2016)

  • Both Win32 and Win64 versions.
  • Redesigned table/view/virtual table editors, using a new recursive-descent SQL parser based on COCO/R.
  • Separate editors for table and column constraints.
  • The change script is available before applying changes to a database object.
  • Experimental SQL formatter on the SQL and DDL tabs.
  • Database schema compare.
  • Settings are now stored in a JSON file.

New in SQLite Expert Professional 3.5.89.2509 (Dec 7, 2015)

  • Improved license registration process.

New in SQLite Expert Professional 3.5.49.2469 (Jun 2, 2014)

  • Added support for partial indexes.
  • Added support for tables without rowid.

New in SQLite Expert Professional 3.5.6.2425 (Dec 10, 2013)

  • Improved license registration process.

New in SQLite Expert Professional 3.4.98.2328 (Nov 4, 2013)

  • Upgraded ICU library to version 52

New in SQLite Expert Professional 3.4.97.2327 (Oct 30, 2013)

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

New in SQLite Expert Professional 3.4.96.2326 (Oct 29, 2013)

  • Fixed error when creating a new table with indexes.

New in SQLite Expert Professional 3.4.95.2325 (Oct 28, 2013)

  • Fixed error when creating foreign keys.

New in SQLite Expert Professional 3.4.94.2324 (Oct 26, 2013)

  • Fixed when applying changes after deleting an index.

New in SQLite Expert Professional 3.4.93.2323 (Oct 26, 2013)

  • Fixed AV when creating table in an empty database.

New in SQLite Expert Professional 3.4.92.2322 (Oct 26, 2013)

  • Fixed error when creating foreign keys.

New in SQLite Expert Professional 3.4.91.2321 (Oct 25, 2013)

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

New in SQLite Expert Professional 3.4.90.2320 (Oct 24, 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 SQLite Expert Professional 3.4.89.2319 (Oct 23, 2013)

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

New in SQLite Expert Professional 3.4.88.2318 (Oct 23, 2013)

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

New in SQLite Expert Professional 3.4.87.2317 (Oct 22, 2013)

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

New in SQLite Expert Professional 3.4.86.2316 (Oct 18, 2013)

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

New in SQLite Expert Professional 3.4.84.2314 (Oct 15, 2013)

  • Fixed errors in handling in memory and attached databases

New in SQLite Expert Professional 3.4.83.2313 (Oct 12, 2013)

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

New in SQLite Expert Professional 3.4.82.2312 (Oct 10, 2013)

  • Fixed an error in generating filter expression

New in SQLite Expert Professional 3.4.81.2311 (Oct 7, 2013)

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

New in SQLite Expert Professional 3.4.80.2310 (Oct 2, 2013)

  • Fixed order of records when pasting data from Excel.

New in SQLite Expert Professional 3.4.79.2309 (Oct 1, 2013)

  • Fixed detection of delimiter when pasting data from Excel

New in SQLite Expert Professional 3.4.78.2308 (Sep 23, 2013)

  • SQLite library 3.8.0.2 included.

New in SQLite Expert Professional 3.4.77.2307 (Sep 7, 2013)

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

New in SQLite Expert Professional 3.4.76.2306 (Aug 28, 2013)

  • SQLite library 3.8 included.

New in SQLite Expert Professional 3.4.75.2305 (Aug 28, 2013)

  • Fixed alternate row color not persisted between sessions.

New in SQLite Expert Professional 3.4.74.2304 (Jul 28, 2013)

  • Fixed tree refresh issue after renaming a table

New in SQLite Expert Professional 3.4.73.2303 (Jul 22, 2013)

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

New in SQLite Expert Professional 3.4.72.2302 (Jul 22, 2013)

  • Fixed incorrect handling of boolean data types

New in SQLite Expert Professional 3.4.71.2301 (Jul 18, 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 SQLite Expert Professional 3.4.70.2300 (Jun 8, 2013)

  • Fixed a few more skin color issues.

New in SQLite Expert Professional 3.4.69.2299 (Jun 4, 2013)

  • Fixed a few skin color issues

New in SQLite Expert Professional 3.4.68.2298 (Jun 4, 2013)

  • Fixed a few skin color issues

New in SQLite Expert Professional 3.4.67.2297 (May 31, 2013)

  • Rolled back changes in the previous version.

New in SQLite Expert Professional 3.4.66.2296 (May 31, 2013)

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

New in SQLite Expert Professional 3.4.65.2295 (May 30, 2013)

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

New in SQLite Expert Professional 3.4.64.2294 (May 27, 2013)

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

New in SQLite Expert Professional 3.4.63.2293 (May 23, 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 SQLite Expert Professional 3.4.62.2292 (May 20, 2013)

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

New in SQLite Expert Professional 3.4.61.2291 (Apr 30, 2013)

  • Fixed character encoding issue in Lua scripting engine.

New in SQLite Expert Professional 3.4.60.2287 (Apr 25, 2013)

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

New in SQLite Expert Professional 3.4.59.2289 (Apr 18, 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 SQLite Expert Professional 3.4.58.2286 (Apr 12, 2013)

  • Added tab indent option for all editors.

New in SQLite Expert Professional 3.4.57.2285 (Apr 5, 2013)

  • Fixed a bug in the SQL parser.

New in SQLite Expert Professional 3.4.56.2284 (Apr 1, 2013)

  • SQLite library version 3.7.16.1 is now included.

New in SQLite Expert Professional 3.4.55.2283 (Mar 28, 2013)

  • Fixed another query builder refresh issue.

New in SQLite Expert Professional 3.4.54.2282 (Mar 27, 2013)

  • Fixed query builder refresh issue

New in SQLite Expert Professional 3.4.53.2281 (Mar 21, 2013)

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

New in SQLite Expert Professional 3.4.52.2280 (Mar 18, 2013)

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

New in SQLite Expert Professional 3.4.51.2279 (Feb 25, 2013)

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

New in SQLite Expert Professional 3.4.50.2278 (Feb 11, 2013)

  • Fixed a bug handling default values.

New in SQLite Expert Professional 3.4.49.2277 (Jan 31, 2013)

  • Fixed a bug in parsing primary key.

New in SQLite Expert Professional 3.4.48.2275 (Jan 22, 2013)

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

New in SQLite Expert Professional 3.4.47.2269 (Dec 8, 2012)

  • Minor user interface improvements.

New in SQLite Expert Professional 3.4.46.2268 (Dec 5, 2012)

  • SQLite library is now compiled with SQLITE_ENABLE_FTS4_UNICODE61.

New in SQLite Expert Professional 3.4.45.2267 (Dec 3, 2012)

  • Pragma 'default_cache_size' is no longer used.

New in SQLite Expert Professional 3.4.44.2266 (Dec 3, 2012)

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

New in SQLite Expert Professional 3.4.43.2265 (Nov 29, 2012)

  • Updated pragma list on database tab.

New in SQLite Expert Professional 3.4.42.2264 (Nov 27, 2012)

  • Fixed error parsing primary key conflict clause.

New in SQLite Expert Professional 3.4.41.2263 (Nov 27, 2012)

  • Fixed encoding issue when importing data from text files

New in SQLite Expert Professional 3.4.39.2261 (Nov 21, 2012)

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

New in SQLite Expert Professional 3.4.37.2259 (Nov 14, 2012)

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

New in SQLite Expert Professional 3.4.36.2258 (Nov 6, 2012)

  • Fixed encoding issue when copying data to clipboard.

New in SQLite Expert Professional 3.4.35.2257 (Oct 31, 2012)

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

New in SQLite Expert Professional 3.4.34.2256 (Oct 16, 2012)

  • Fixed startup error on Windows 2000.

New in SQLite Expert Professional 3.4.33.2255 (Oct 8, 2012)

  • SQLite library 3.7.14.1 included.

New in SQLite Expert Professional 3.4.32.2254 (Sep 27, 2012)

  • Fixed encoding issue when copying data to clipboard

New in SQLite Expert Professional 3.4.31.2253 (Sep 19, 2012)

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

New in SQLite Expert Professional 3.4.30.2252 (Sep 19, 2012)

  • Fixed bug in character encoding detection when loading text files

New in SQLite Expert Professional 3.4.29.2251 (Sep 18, 2012)

  • Fixed an error in internal SQL parser

New in SQLite Expert Professional 3.4.28.2250 (Sep 17, 2012)

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

New in SQLite Expert Professional 3.4.27.2249 (Sep 13, 2012)

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

New in SQLite Expert Professional 3.4.26.2248 (Sep 10, 2012)

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

New in SQLite Expert Professional 3.4.25.2247 (Aug 27, 2012)

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

New in SQLite Expert Professional 3.4.24.2246 (Aug 20, 2012)

  • Improved the timing of queries having unbound parameters.

New in SQLite Expert Professional 3.4.23.2245 (Aug 20, 2012)

  • Fixed a bug in foreign key parsing

New in SQLite Expert Professional 3.4.22.2244 (Aug 20, 2012)

  • Minor DATE/DATETIME fixes.

New in SQLite Expert Professional 3.4.21.2243 (Jul 27, 2012)

  • Fixed bug in filtering DATE/DATETIME fields.

New in SQLite Expert Professional 3.4.20.2242 (Jul 16, 2012)

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

New in SQLite Expert Professional 3.4.19.2241 (Jul 2, 2012)

  • Fixed skin support on the main toolbar.

New in SQLite Expert Professional 3.4.18.2240 (Jun 30, 2012)

  • Added Ctrl+Enter shortcut for record editor.

New in SQLite Expert Professional 3.3.55 Build 2206 (Jan 16, 2012)

  • Fixed an issue in restructuring tables having default values.

New in SQLite Expert Professional 3.3.54 Build 2205 (Jan 16, 2012)

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

New in SQLite Expert Professional 3.3.53 Build 2204 (Jan 16, 2012)

  • Fixed case sensitivity issue in search/replace dialog

New in SQLite Expert Professional 3.3.52 Build 2203 (Jan 16, 2012)

  • Modified error reporting options to include only basic debug information

New in SQLite Expert Professional 3.3.51 Build 2202 (Jan 16, 2012)

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

New in SQLite Expert Professional 3.3.50 Build 2201 (Jan 16, 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 SQLite Expert Professional 3.3.49 Build 2200 (Jan 16, 2012)

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

New in SQLite Expert Professional 3.3.48 Build 2199 (Jan 16, 2012)

  • Fixed a bug in retrieving the SQLite error message

New in SQLite Expert Professional 3.3.47 Build 2198 (Jan 16, 2012)

  • Fixed bug in exporting GUID values to CSV

New in SQLite Expert Professional 3.3.46 Build 2196 (Jan 16, 2012)

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

New in SQLite Expert Professional 3.3.45 Build 2195 (Jan 16, 2012)

  • Fixed incorrect ordering on Database tab

New in SQLite Expert Professional 3.3.44 Build 2194 (Oct 10, 2011)

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

New in SQLite Expert Professional 3.3.42 Build 2192 (Sep 24, 2011)

  • DOCID is now preserved when restructuring virtual table.

New in SQLite Expert Professional 3.3.33 Build 2174 (Aug 8, 2011)

  • Minor internal fixes.

New in SQLite Expert Professional 3.3.30 Build 2166 (Jul 15, 2011)

  • Updated help file.

New in SQLite Expert Professional 3.3.27 Build 2157 (May 21, 2011)

  • SQLite library 3.7.6.3 is now included.

New in SQLite Expert Professional 3.3.26 Build 2156 (May 21, 2011)

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

New in SQLite Expert Professional 3.3.25 Build 2155 (May 21, 2011)

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

New in SQLite Expert Professional 3.3.24 Build 2154 (May 9, 2011)

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

New in SQLite Expert Professional 3.3.23 Build 2153 (May 9, 2011)

  • Fixed bug in index editor.

New in SQLite Expert Professional 3.3.22 Build 2152 (May 9, 2011)

  • Improved JPEG image format detection.

New in SQLite Expert Professional 3.3.21 Build 2151 (May 9, 2011)

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

New in SQLite Expert Professional 3.3.20 Build 2150 (Apr 22, 2011)

  • The record count feature is now optional.

New in SQLite Expert Professional 3.3.19 Build 2149 (Apr 21, 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 SQLite Expert Professional 3.3.17 Build 2147 (Apr 18, 2011)

  • SQLite library 3.7.6.2 is now included.

New in SQLite Expert Professional 3.3.16 Build 2146 (Apr 18, 2011)

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

New in SQLite Expert Professional 3.3.15 Build 2145 (Apr 16, 2011)

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

New in SQLite Expert Professional 3.3.14 Build 2144 (Apr 16, 2011)

  • Fixed AV after opening and canceling the Options window.

New in SQLite Expert Professional 3.3.13 Build 2143 (Apr 16, 2011)

  • Fixed error in refreshing schema after deleting an object.

New in SQLite Expert Professional 3.3.12 Build 2142 (Apr 16, 2011)

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

New in SQLite Expert Professional 3.3.11 Build 2141 (Apr 16, 2011)

  • SQLite library 3.7.6 is now included.

New in SQLite Expert Professional 3.3.10 Build 2140 (Apr 16, 2011)

  • Fixed program startup error when using auto-extensions.

New in SQLite Expert Professional 3.3.9 Build 2139 (Apr 16, 2011)

  • Added support for the ICU extension.

New in SQLite Expert Professional 3.3.8 Build 2138 (Apr 16, 2011)

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

New in SQLite Expert Professional 3.3.7 Build 2137 (Apr 16, 2011)

  • Fixed bug in importing null values from CSV files.

New in SQLite Expert Professional 3.3.6 Build 2136 (Apr 16, 2011)

  • Added database online backup option.

New in SQLite Expert Professional 3.3.3 Build 2133 (Mar 28, 2011)

  • Added database DDL compare tool.

New in SQLite Expert Professional 3.3.2 Build 2132 (Mar 21, 2011)

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

New in SQLite Expert Professional 3.3.1 Build 2131 (Mar 21, 2011)

  • Added support for RTREE virtual tables.

New in SQLite Expert Professional 3.3.0 Build 2130 (Mar 18, 2011)

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

New in SQLite Expert Professional 3.2.22 Build 2122 (Mar 18, 2011)

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

New in SQLite Expert Professional 3.2.21 Build 2121 (Mar 18, 2011)

  • Fixed a bug in refreshing schema.

New in SQLite Expert Professional 3.2.20 Build 2120 (Mar 18, 2011)

  • Fixed a bug in the internal parser.

New in SQLite Expert Professional 3.2.19 Build 2119 (Mar 18, 2011)

  • Improved tabbed navigation on the record editor.

New in SQLite Expert Professional 3.2.18 Build 2118 (Mar 18, 2011)

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

New in SQLite Expert Professional 3.2.17 Build 2117 (Mar 18, 2011)

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

New in SQLite Expert Professional 3.2.16 Build 2116 (Mar 18, 2011)

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

New in SQLite Expert Professional 3.2.15 Build 2115 (Feb 7, 2011)

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

New in SQLite Expert Professional 3.2.13 Build 2113 (Feb 2, 2011)

  • Fixed a registry error when reading file associations

New in SQLite Expert Professional 3.2.12 Build 2112 (Jan 21, 2011)

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

New in SQLite Expert Professional 3.2.11 Build 2111 (Jan 19, 2011)

  • Fixed incorrect application title in Professional Edition.

New in SQLite Expert Professional 3.2.10 Build 2110 (Jan 8, 2011)

  • Upgraded external SQLite library to 3.7.4.

New in SQLite Expert Professional 3.2.9 Build 2109 (Jan 7, 2011)

  • Minor UI fixes.

New in SQLite Expert Professional 3.2.8 Build 2108 (Jan 5, 2011)

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

New in SQLite Expert Professional 3.2.7 Build 2107 (Jan 5, 2011)

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

New in SQLite Expert Professional 3.2.6 Build 2106 (Dec 17, 2010)

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

New in SQLite Expert Professional 3.2.5 Build 2105 (Nov 16, 2010)

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

New in SQLite Expert Professional 3.2.4 Build 2104 (Nov 15, 2010)

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

New in SQLite Expert Professional 3.2.3 Build 2103 (Nov 15, 2010)

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

New in SQLite Expert Professional 3.2.2 Build 2102 (Nov 12, 2010)

  • Minor corrections to the Pascal script engine.

New in SQLite Expert Professional 3.2.1 Build 2101 (Nov 11, 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 SQLite Expert Professional 3.2.0 Build 2100 (Nov 11, 2010)

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

New in SQLite Expert Professional 3.1.23 Build 2099 (Nov 11, 2010)

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

New in SQLite Expert Professional 3.1.22 Build 2098 (Oct 10, 2010)

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

New in SQLite Expert Professional 3.1.21 Build 2097 (Oct 9, 2010)

  • SQLite library version 3.7.3 included.

New in SQLite Expert Professional 3.1.20 Build 2096 (Oct 8, 2010)

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

New in SQLite Expert Professional 3.1.19 Build 2095 (Oct 7, 2010)

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

New in SQLite Expert Professional 3.1.18 Build 2094 (Oct 6, 2010)

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

New in SQLite Expert Professional 3.1.17 Build 2093 (Oct 2, 2010)

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

New in SQLite Expert Professional 3.1.16 Build 2092 (Oct 1, 2010)

  • Fixed SQLite library not restored at application startup.

New in SQLite Expert Professional 3.1.15 Build 2091 (Sep 29, 2010)

  • Fixed bug in restoring SQL history at application startup.

New in SQLite Expert Professional 3.1.14 Build 2090 (Sep 27, 2010)

  • Implemented some schema refresh optimizations.

New in SQLite Expert Professional 3.1.13 Build 2089 (Sep 27, 2010)

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

New in SQLite Expert Professional 3.1.12 Build 2088 (Sep 27, 2010)

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

New in SQLite Expert Professional 3.1.11 Build 2087 (Sep 14, 2010)

  • Added option to open multiple SQL tabs.

New in SQLite Expert Professional 3.1.10 Build 2086 (Sep 10, 2010)

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

New in SQLite Expert Professional 3.1.9 Build 2085 (Sep 2, 2010)

  • Added word-wrap option for SQL editors.

New in SQLite Expert Professional 3.1.8 Build 2084 (Sep 2, 2010)

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

New in SQLite Expert Professional 3.1.7 Build 2083 (Sep 1, 2010)

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

New in SQLite Expert Professional 3.1.6 Build 2082 (Sep 1, 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 SQLite Expert Professional 3.1.5 Build 2081 (Aug 25, 2010)

  • SQLite library 3.7.2 included.

New in SQLite Expert Professional 3.1.4 Build 2080 (Aug 23, 2010)

  • Fixed navigator buttons not working on the SQL tabs.

New in SQLite Expert Professional 3.1.3 Build 2079 (Aug 23, 2010)

  • Fixed record number not showing on the SQL grids.

New in SQLite Expert Professional 3.1.2 Build 2078 (Aug 23, 2010)

  • SQLite library 3.7.1 included.

New in SQLite Expert Professional 3.1.1 Build 2077 (Aug 23, 2010)

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

New in SQLite Expert Professional 3.1.0 Build 2076 (Aug 23, 2010)

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

New in SQLite Expert Professional 3.0.40 Build 2075 (Aug 20, 2010)

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

New in SQLite Expert Professional 3.0.39 Build 2074 (Aug 7, 2010)

  • SQLite library 3.7.0.1 included.

New in SQLite Expert Professional 3.0.38 Build 2073 (Aug 7, 2010)

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

New in SQLite Expert Professional 3.0.37 Build 2072 (Aug 7, 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 SQLite Expert Professional 3.0.36 Build 2071 (Aug 7, 2010)

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

New in SQLite Expert Professional 3.0.35 Build 2070 (Aug 2, 2010)

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

New in SQLite Expert Professional 3.0.34 Build 2069 (Aug 2, 2010)

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

New in SQLite Expert Professional 3.0.33 Build 2068 (Jul 29, 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 SQLite Expert Professional 2.4.46 Build 2027 (May 27, 2010)

  • Fixed bug in handling savepoints with duplicate names.

New in SQLite Expert Professional 2.4.45 Build 2026 (May 18, 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 SQLite Expert Professional 2.4.44 Build 2025 (May 13, 2010)

  • Fixed table filter being removed when resizing the window.

New in SQLite Expert Professional 2.4.43 Build 2024 (May 13, 2010)

  • Fixed a few toolbar visibility issues

New in SQLite Expert Professional 2.4.42 Build 2022 (May 12, 2010)

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

New in SQLite Expert Professional 2.4.41 Build 2021 (May 12, 2010)

  • Minor bug fixes.

New in SQLite Expert Professional 2.4.40 Build 2020 (May 12, 2010)

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

New in SQLite Expert Professional 2.4.39 Build 2019 (May 10, 2010)

  • Minor UI improvements.

New in SQLite Expert Professional 2.4.37 Build 2017 (May 10, 2010)

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

New in SQLite Expert Professional 2.4.34 Build 2014 (May 10, 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 SQLite Expert Professional 2.4.31 Build 2011 (May 10, 2010)

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

New in SQLite Expert Professional 2.4.25 Build 2005 (May 10, 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 SQLite Expert Professional 2.4.21 Build 2001 (May 10, 2010)

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

New in SQLite Expert Professional 2.4.14 Build 1994 (May 10, 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 SQLite Expert Professional 2.4.10 Build 1990 (May 10, 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 SQLite Expert Professional 2.4.6 Build 1986 (May 10, 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 SQLite Expert Professional 2.4.2 Build 1982 (May 10, 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 SQLite Expert Professional 2.4.0 Build 1980 (May 10, 2010)

  • Added options for code completion.

New in SQLite Expert Professional 2.3.56 Build 1974 (May 10, 2010)

  • Added experimental code completion.

New in SQLite Expert Professional 2.2.9 Build 1910 (Nov 2, 2009)

  • Fixed a minor bug in the foreign key editor.

New in SQLite Expert Professional 2.2.8 Build 1909 (Oct 30, 2009)

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

New in SQLite Expert Professional 2.2.7 Build 1908 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.2.6 Build 1907 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.2.5 Build 1906 (Oct 27, 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 SQLite Expert Professional 2.2.4 Build 1905 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.2.3 Build 1904 (Oct 27, 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 SQLite Expert Professional 2.2.2 Build 1903 Beta (Oct 27, 2009)

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

New in SQLite Expert Professional 2.2.1 Build 1902 Beta (Oct 27, 2009)

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

New in SQLite Expert Professional 2.2.0 Build 1901 Beta (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.27 Build 1896 (Oct 27, 2009)

  • Updated definition of site license in the license agreement.

New in SQLite Expert Professional 2.1.26 Build 1895 (Oct 27, 2009)

  • A few cosmetic UI fixes. .

New in SQLite Expert Professional 2.1.25 Build 1894 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.24 Build 1893 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.23 Build 1892 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.22 Build 1891 (Oct 27, 2009)

  • Added thumb tracking option for grid scrollbars.

New in SQLite Expert Professional 2.1.21 Build 1890 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.20. Build 1889 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.19. Build 1888 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.18. Build 1887 (Oct 27, 2009)

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

New in SQLite Expert Professional 2.1.27 Build 1896 (Oct 15, 2009)

  • Updated definition of site license in the license agreement.

New in SQLite Expert Professional 2.1.26 Build 1895 (Oct 12, 2009)

  • A few cosmetic UI fixes.

New in SQLite Expert Professional 2.1.25 Build 1894 (Oct 12, 2009)

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

New in SQLite Expert Professional 2.1.24 Build 1893 (Oct 2, 2009)

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

New in SQLite Expert Professional 2.1.23 Build 1892 (Oct 1, 2009)

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

New in SQLite Expert Professional 2.1.22 Build 1891 (Sep 30, 2009)

  • Added thumb tracking option for grid scrollbars.

New in SQLite Expert Professional 2.1.21 Build 1890 (Sep 29, 2009)

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

New in SQLite Expert Professional 2.1.20 Build 1889 (Sep 29, 2009)

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

New in SQLite Expert Professional 2.1.19 Build 1888 (Sep 28, 2009)

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

New in SQLite Expert Professional 2.1.18 Build 1887 (Sep 28, 2009)

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

New in SQLite Expert Professional 2.1.17 Build 1886 (Sep 23, 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 SQLite Expert Professional 2.1.16 Build 1885 (Sep 21, 2009)

  • A few more internal fixes in the Query Builder.

New in SQLite Expert Professional 2.1.15 Build 1884 (Sep 20, 2009)

  • Fixed a repainting issue on Query Builder.

New in SQLite Expert Professional 2.1.14 Build 1883 (Sep 20, 2009)

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

New in SQLite Expert Professional 2.1.13 Build 1882 (Sep 19, 2009)

  • Minor usability improvements.

New in SQLite Expert Professional 2.1.12 Build 1881 (Sep 17, 2009)

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

New in SQLite Expert Professional 2.1.11 Build 1879 (Sep 16, 2009)

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

New in SQLite Expert Professional 2.1.10 Build 1878 (Sep 16, 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 SQLite Expert Professional 2.1.9 Build 1877 (Sep 16, 2009)

  • Added support for loaded extensions.

New in SQLite Expert Professional 2.1.8 Build 1876 (Sep 14, 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 SQLite Expert Professional 2.1.7 Build 1875 (Sep 11, 2009)

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

New in SQLite Expert Professional 2.1.6 Build 1874 (Sep 10, 2009)

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

New in SQLite Expert Professional 2.1.5 Build 1873 (Sep 9, 2009)

  • Fixed error preventing the opening of attached databases at startup

New in SQLite Expert Professional 2.1.4 Build 1872 (Sep 8, 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 SQLite Expert Professional 2.1.3 Build 1871 (Sep 5, 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 SQLite Expert Professional 2.1.2 Build 1870 (Sep 4, 2009)

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

New in SQLite Expert Professional 2.1.1 Build 1869 (Sep 3, 2009)

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

New in SQLite Expert Professional 2.1.0 Build 1865 (Aug 31, 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 SQLite Expert Professional 2.0.45 Build 1863 (Aug 9, 2009)

  • Disabled Paste from clipboard into read-only datasets.

New in SQLite Expert Professional 2.0.44 Build 1862 (Aug 9, 2009)

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

New in SQLite Expert Professional 2.0.43 Build 1861 (Jul 27, 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 SQLite Expert Professional 2.0.42 Build 1860 (Jul 4, 2009)

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

New in SQLite Expert Professional 2.0.41 Build 1859 (Jul 2, 2009)

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

New in SQLite Expert Professional 2.0.40 Build 1858 (Jul 2, 2009)

  • SQLite library 3.6.16 is now included.

New in SQLite Expert Professional 2.0.39 Build 1857 (Jul 2, 2009)

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

New in SQLite Expert Professional 2.0.38 Build 1856 (Jun 23, 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 SQLite Expert Professional 2.0.37 Build 1855 (Jun 19, 2009)

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

New in SQLite Expert Professional 2.0.36 Build 1854 (Jun 5, 2009)

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

New in SQLite Expert Professional 2.0.35 Build 1853 (Jun 5, 2009)

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

New in SQLite Expert Professional 2.0.34 Build 1852 (Jun 5, 2009)

  • Added support for displaying GIF images in grids.

New in SQLite Expert Professional 2.0.33 Build 1851 (Jun 5, 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 SQLite Expert Professional 2.0.32 Build 1850 (Jun 5, 2009)

  • A few minor internal fixes.

New in SQLite Expert Professional 2.0.31 Build 1849 (Jun 5, 2009)

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

New in SQLite Expert Professional 2.0.30 Build 1848 (Jun 5, 2009)

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

New in SQLite Expert Professional 2.0.29 Build 1847 (Jun 5, 2009)

  • A few minor internal fixes.

New in SQLite Expert Professional 2.0.28 Build 1846 (May 22, 2009)

  • A few minor internal fixes.

New in SQLite Expert Professional 2.0.27 Build 1845 (May 22, 2009)

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

New in SQLite Expert Professional 2.0.26 Build 1844 (May 22, 2009)

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

New in SQLite Expert Professional 2.0.25 Build 1843 (May 22, 2009)

  • Fixed an error in the image format detection routines.

New in SQLite Expert Professional 2.0.24 Build 1842 (May 22, 2009)

  • Fixed bug causing the encryption keys to be incorrectly persisted

New in SQLite Expert Professional 2.0.23 Build 1841 (May 22, 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 SQLite Expert Professional 2.0.22 Build 1840 (May 8, 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 SQLite Expert Professional 2.0.21 Build 1839 (May 8, 2009)

  • A few cosmetic changes to the index designer.

New in SQLite Expert Professional 2.0.20 Build 1838 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.19 Build 1837 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.18 Build 1834 (May 8, 2009)

  • Fixed an error in record filter.

New in SQLite Expert Professional 2.0.17 Build 1832 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.16 Build 1831 (May 8, 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 SQLite Expert Professional 2.0.15 Build 1830 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.14 Build 1829 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.13 Build 1828 (May 8, 2009)

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

New in SQLite Expert Professional 2.0.12 Build 1826 (Apr 24, 2009)

  • Minor corrections to the data transfer wizard.

New in SQLite Expert Professional 2.0.0 Build 1802 (Apr 14, 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 SQLite Expert Professional 1.7.89 Build 1790 (Apr 14, 2009)

  • SQLite library 3.6.12 is now included.

New in SQLite Expert Professional 1.7.87 Build 1788 (Mar 29, 2009)

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

New in SQLite Expert Professional 1.7.86 Build 1787 (Mar 15, 2009)

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

New in SQLite Expert Professional 1.7.82 Build 1783 (Feb 28, 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 SQLite Expert Professional 1.7.79 Build 1780 (Feb 16, 2009)

  • Fixed a minor parser error.

New in SQLite Expert Professional 1.7.78. build 1779 (Feb 10, 2009)

  • Fixed a few minor issues in field editing.

New in SQLite Expert Professional 1.7.75 Build 1776 (Jan 31, 2009)

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

New in SQLite Expert Professional 1.7.73 Build 1774 (Jan 17, 2009)

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

New in SQLite Expert Professional 1.7.71 Build 1772 (Jan 5, 2009)

  • Fixed tab behavior on script editor windows.

New in SQLite Expert Professional 1.7.68 Build 1769 (Dec 23, 2008)

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

New in SQLite Expert Professional 1.7.66 Build 1767 (Dec 19, 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 SQLite Expert Professional 1.6.65 Build 1577 (May 16, 2008)

  • Minor user interface changes.