

#Navicat for sqlite key upgrade#
Upgrade Procedure : click here to upgrade Navicat freezed when applying "Beautify SQL" on some SQL statements."Navicat is not able to prase SQL" error occured in Query Editor.The automatic word wrap in TEXT fields not working properly in Form View.Access Violation error occured when exporting chart report to excel file.Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.group like "ITem" and it didn't allow to change into "Item". Improved virtual grouping rename issue - e.g.Improved smart quote identifier for SQLite.Support encrypted SQLite file (wxSQLite3).Hang issue occurred when launching Import Wizard.Unknown Internal error occurred when backup in Automation in some cases.Unknown Internal error occurred when writing query in some cases."Use empty string as NULL" option did not work in Import Wizard.High memory usage issue in Data Synchronization.Unknown Internal error occurred when opening tables in some cases.Unknown Internal error occurred when running old version export profiles in Automation.Table menu displayed wrong item in some cases.Unknown Internal error occurred when running query with parameters.

Beautify SQL did not format multiple statements properly in SQL Editor.
#Navicat for sqlite key code#

Foreign Key constraint issue in Import Wizard.Some setting values was missing in SQLite Trigger Designer.Foreign Key constraint didn't work when the constraint name was empty in SQLite.Crashed when dumping table to sql file in some cases.Unable to disable Foreign Key constraint in Data Synchronization.Unable to edit query results in some cases."SQL Logic" error occurred when loading SQLite extension.Unable to drag and drop a query into a group in some cases.Column width did not retain after hide and show the column in Table Viewer.The color of function keywords did not change according to the Font Color settings in Options.Unable to create a query inside a group.
