Start Produkty Navicat dla SQLite Release Note

Release Notes

Windows


If you have purchased our products and want to retrieve the download information of the latest version, please click here

Aug 30 2010
Navicat for SQLite (Windows) version 9.0.13 is now available

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. Index/trigger was unable to be removed from the Navicat main window.
  2. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.

Upgrade Procedure : click here to upgrade

Aug 2 2010
Navicat for SQLite (Windows) version 9.0.12 is now available

Bug Fixes:

  1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  3. When exporting numeric data to excel file, it would be exported as string type.

Upgrade Procedure : click here to upgrade

Jul 15 2010
Navicat for SQLite (Windows) version 9.0.11 is now available

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  3. Foreign Key link position in Visual Builder were not accurate enough.
  4. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  5. Server Monitor would crash if being opened for a while.
  6. The info column in Server Monitor only showed (WIDEMEMO).
  7. Object Selection in Restore window wrongly displayed items "Indexes" and "Triggers".

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for SQLite (Windows) version 9.0.10 is now available

Bug Fixes:

  1. Beautify SQL would cause error if extra spaces existed in aggregate function.
  2. Fixed error when importig XML files from the Interent.
  3. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  4. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

Jun 8 2010
Navicat for SQLite (Windows) version 9.0.9 is now available

Bug Fixes:

  1. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
  2. Each field was limited to 65536 bytes.
  3. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
  4. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

May 31 2010
Navicat for SQLite (Windows) version 9.0.8 is now available

Improvements:

  1. Added more popup option for Where and Having clauses in Query Builder.

Bug Fixes:

  1. In Navicat main, View -> Sort did not work properly.
  2. In Navicat main, copying action would not work properly after certain user actions.
  3. In Navicat main, Window -> Next Window did not work properly.
  4. When adding new field and tabbing across cloumns in Table Designer, bule hash would appear at the end of the columns.
  5. When tabbing betweem columns in Table Deisgner, some columns would be skipped.
  6. Beautify SQL feature did not compatible with Navicat Query Parameter syntax, so that error would occur when running the parameter query.

Upgrade Procedure : click here to upgrade

May 17 2010
Navicat for SQLite (Windows) version 9.0.7 is now available

Improvements:

  1. Support encrypted SQLite file (wxSQLite3).
  2. Improved smart quote identifier for SQLite.
  3. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
  4. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
  5. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
  6. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
  7. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
  8. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.

Bug Fixes:

  1. Access Violation error occured when exporting chart report to excel file.
  2. The automatic word wrap in TEXT fields not working properly in Form View.
  3. "Navicat is not able to prase SQL" error occured in Query Editor.
  4. Navicat freezed when applying "Beautify SQL" on some SQL statements.

Upgrade Procedure : click here to upgrade

May 10 2010
Navicat for SQLite (Windows) version 9.0.6 is now available

Improvements:

  1. Support Cancel action in copying SQLite objects, table and query.

Bug Fixes:

  1. The font size used in Query grid was smaller than in View grid.
  2. "Set Display Format" option in Table Viewer did not work in numerical field.
  3. Fixed the wrong positioning issue of main menu items.

Upgrade Procedure : click here to upgrade

May 3 2010
Navicat for SQLite (Windows) version 9.0.5 is now available

Improvements:

  1. Improved the performance for opening Table Viewer with huge amount of columns.

Bug Fixes:

  1. When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark.
  2. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
  3. "Access violation" error occured in Foreign Key Data Selection feature if SQLite reference table did not exist.
  4. Fixed the column width of SQLite Foreign Key Data Selection window.
  5. Schedule profile could not be loaded in main window.
  6. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
  7. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
  8. When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
  9. Fixed GUI problem when opened Edit -> Options in SQLite Table Designer.
  10. "Access violation" error occured for code/word completion feature.

Upgrade Procedure : click here to upgrade

Apr 26 2010
Navicat for SQLite (Windows) version 9.0.4 is now available

Improvements:

  1. Better handle case sensitive of object identifier for Query Builder.
  2. Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
  3. Improved keywords list for Code/Word Completion.
  4. Attached hot keys to the navigation bar in Table Viewer.

Bug Fixes:

  1. Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
  2. Toolbar would blink when toggling taskbar auto hide option.
  3. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
  4. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

Upgrade Procedure : click here to upgrade

Apr 12 2010
Navicat for SQLite (Windows) version 9.0.3 is now available

Main Features:

Common SQLite support:

  1. Work with SQLite 2 and SQLite 3.
  2. Support of all SQLite objects and subobjects
  3. Support of character set and unicode.

Connection Management:

  1. Multiple local/remote SQLite server connections.
  2. Connection to SQLite database through HTTP.
  3. Import/Export connections settings.

Well-designed user interface:

  1. Virtual Grouping for connections and objects.
  2. Customize of connection order.
  3. Grid View and Form View support.
  4. Well-described Wizard System.
  5. Provide well-vision for users in table grid.
  6. Support dock windows.

Powerful data management tool:

  1. Foreign Key Data Selection.
  2. Supports Parameter Query.
  3. Import and Export support.
  4. Data Transfer support.
  5. Data Synchronization support.
  6. Support of Backup and Restore.

Visual Designer:

  1. Support Code-Completion in SQL editors.
  2. Support Views in Query Builder.
  3. Support of Views Builder.
  4. Support SQL Previewer.

Additional features:

  1. Print Schema / Table Structure.
  2. Support of setting global Row Height and Column Width in table grid.
  3. Support of Word Wrap.
  4. Provides a short-cut to terminate a running query.
  5. Code Folding.
  6. Matched Brace/Bracket Highlighting.
  7. Parameter Tips.
  8. Zoom In/Out for SQL editors.
  9. SQL Beautifier.
  10. Favorites.
  11. Object Filter.
  12. Unicode Character Report.
  13. Auto save in Query, Function etc.
  14. Custom sort in Tabler Viewer.
  15. Notification email supports SSL/TLS in Schedule.
  16. History Log Viewer.

Download here

Mac OS X


If you have purchased our products and want to retrieve the download information of the latest version, please click here

Aug 30 2010
Navicat for SQLite (Mac) version 9.0.10 is now available

Improvements:

  1. "Test Connection" action can now be canceled in Connection Properties.
  2. Text Qualifier can now be freely set to any characters during Import Wizard.

Bug Fixes:

  1. If a group contained more than two connections, error would occur when trying to delete the group.
  2. Updated rows in Query Viewer were reverted back to their previous value after highlighting another rows.
  3. Navicat hanged when importing multiple files using Import Wizard.
  4. Error message could not be displayed if "Continue on Error" was not checked in Data Transfer.
  5. Memory allocation problem when the manual was opened.

Upgrade Procedure : click here to upgrade

Jul 29 2010
Navicat for SQLite (Mac) version 9.0.9 is now available

Bug Fixes:

  1. In Mac OS X 10.4, Navicat would crash when opening tables with foreign keys.
  2. Menu bar did not display properly when running in Mac OS X 10.4.
  3. Navicat hanged when switching to some object pages in main window when running in Mac OS X 10.4.
  4. Some buttons and text were not displayed properly in Mac OS X 10.4.

Upgrade Procedure : click here to upgrade

Jul 5 2010
Navicat for SQLite (Mac) version 9.0.8 is now available

Improvements:

  1. Connection name is now shown in the title bar of Console window.

Bug Fixes:

  1. If the decimal symbol was not set as period (.), incorrect decimal values may be imported for excel files.

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for SQLite (Mac) version 9.0.7 is now available

Bug Fixes:

  1. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
  2. Failed to prompt for entering HTTP authentication password even password was not saved.
  3. Data Synchronization did not work for SQLite databases.

Upgrade Procedure : click here to upgrade

Jun 9 2010
Navicat for SQLite (Mac) version 9.0.6 is now available

Improvements:

  1. Show the host information under Connection Information view.

Bug Fixes:

  1. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
  2. Incorrect values were synchronized during Data Synchronization.
  3. Crashed easily when running queries in Query Viewer.

Upgrade Procedure : click here to upgrade

May 20 2010
Navicat for SQLite (Mac) version 9.0.5 is now available

Improvements:

  1. Support encrypted SQLite file (wxSQLite3).
  2. Support to browse SQLite library path.
  3. SQLite Console now uses Navicat's console instead of using the SQLite binary.
  4. SQLite Transaction is now used when changing some existing object, preventing accidental dropping of objects.
  5. If the row is selected, Filter Wizard will now display the words in white color.
  6. Query Builder supports to show diagram for some incomplete statement.

Bug Fixes:

  1. Crashed when getting server Information on Information View if connection failed.
  2. Improper join lines were displayed when joining multiple tables in Query Builder.
  3. Crashed when parsing some improper SQL statements.

Upgrade Procedure : click here to upgrade

May 5 2010
Navicat for SQLite (Mac) version 9.0.4 is now available

Improvements:

  1. Added a section in Query View Result tab so that it can now show the sql and the query time.
  2. Query result data can now be exported even if the sql is not saved.

Bug Fixes:

  1. Failed to edit table data under HTTP Tunnel connection.
  2. Failed to edit data in Views.
  3. View Builder could not generate the corresponding GUI component from the query in View Editor.
  4. Crashed when running SQL query under HTTP tunnel connections.
  5. Failed to delete data inside the cells in Table Viewer by pressing Delete button.

Upgrade Procedure : click here to upgrade

Apr 30 2010
Navicat for SQLite (Mac) version 9.0.3 is now available

Improvements:

  1. Added shortcut keys for bottom bar buttons in Table Viewer.
  2. Adjusted the cell editable only when those data is allowed to update in Query Viewer.
  3. Improved the dynamic width for Code/Word completion window.
  4. New lines are now not exported as \n during Export Wizard.

Bug Fixes:

  1. Dragging images into Image Editor were converted to tiff format.
  2. "Format" menu flashed frequently on Mac 10.5.
  3. Table could not be duplicated if the table name was quoted by ` ` or [ ] in the ddl of that table.
  4. Some SQL statements would cause Navicat crashed when switching to Query Builder.

Upgrade Procedure : click here to upgrade

Apr 12 2010
Navicat for SQLite (Mac) version 9.0.2 is now available

Main Features:

Common SQLite support:

  1. Work with SQLite 2 and SQLite 3.
  2. Support of all SQLite objects and subobjects
  3. Support of character set and unicode.

Connection Management:

  1. Multiple local/remote SQLite server connections.
  2. Connection to SQLite database through HTTP.
  3. Import/Export connections settings.

Well-designed user interface:

  1. Virtual Grouping for connections and objects.
  2. Customize of connection order.
  3. Grid View and Form View support.
  4. Well-described Wizard System.
  5. Provide well-vision for users in table grid.
  6. Support dock windows.

Powerful data management tool:

  1. Foreign Key Data Selection.
  2. Supports Parameter Query.
  3. Import and Export support.
  4. Data Transfer support.
  5. Data Synchronization support.
  6. Support of Backup and Restore.

Visual Designer:

  1. Support Code-Completion in SQL editors.
  2. Support Views in Query Builder.
  3. Support of Views Builder.
  4. Support SQL Previewer.

Additional features:

  1. Print Schema / Table Structure.
  2. Support of setting global Row Height and Column Width in table grid.
  3. Support of Word Wrap.
  4. Provides a short-cut to terminate a running query.
  5. Code Folding.
  6. Matched Brace/Bracket Highlighting.
  7. Parameter Tips.
  8. Zoom In/Out for SQL editors.
  9. SQL Beautifier.
  10. Favorites.
  11. Object Filter.
  12. Unicode Character Report.
  13. Auto save in Query, Function etc.
  14. Custom sort in Tabler Viewer.
  15. Notification email supports SSL/TLS in Schedule.
  16. History Log Viewer.

Download here

Linux


If you have purchased our products and want to retrieve the download information of the latest version, please click here

Aug 30 2010
Navicat for SQLite (Linux) version 9.0.13 is now available

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. Index/trigger was unable to be removed from the Navicat main window.
  2. "Access violation" error sometimes occurred when running an invalid syntax in Query Editor.
  3. "Error in updating task" error occurred when saving a scheduled task.
  4. Error occurred when schedule name and path contained unicode string.

Upgrade Procedure : click here to upgrade

Aug 2 2010
Navicat for SQLite (Linux) version 9.0.12 is now available

Bug Fixes:

  1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  3. When exporting numeric data to excel file, it would be exported as string type.

Upgrade Procedure : click here to upgrade

Jul 15 2010
Navicat for SQLite (Linux) version 9.0.11 is now available

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  3. Foreign Key link position in Visual Builder were not accurate enough.
  4. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  5. Server Monitor would crash if being opened for a while.
  6. The info column in Server Monitor only showed (WIDEMEMO).
  7. Object Selection in Restore window wrongly displayed items "Indexes" and "Triggers".

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for SQLite (Linux) version 9.0.10 is now available

Improvements:

  1. libcurl.dll library updated.

Bug Fixes:

  1. Beautify SQL would cause error if extra spaces existed in aggregate function.
  2. Fixed error when importig XML files from the Interent.
  3. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  4. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

Jun 8 2010
Navicat for SQLite (Linux) version 9.0.9 is now available

Main Features:

Common SQLite support:

  1. Work with SQLite 2 and SQLite 3.
  2. Support of all SQLite objects and subobjects
  3. Support of character set and unicode.

Connection Management:

  1. Multiple local/remote SQLite server connections.
  2. Connection to SQLite database through HTTP.
  3. Import/Export connections settings.

Well-designed user interface:

  1. Virtual Grouping for connections and objects.
  2. Customize of connection order.
  3. Grid View and Form View support.
  4. Well-described Wizard System.
  5. Provide well-vision for users in table grid.
  6. Support dock windows.

Powerful data management tool:

  1. Foreign Key Data Selection.
  2. Supports Parameter Query.
  3. Import and Export support.
  4. Data Transfer support.
  5. Data Synchronization support.
  6. Support of Backup and Restore.

Visual Designer:

  1. Support Code-Completion in SQL editors.
  2. Support Views in Query Builder.
  3. Support of Views Builder.
  4. Support SQL Previewer.

Additional features:

  1. Print Schema / Table Structure.
  2. Support of setting global Row Height and Column Width in table grid.
  3. Support of Word Wrap.
  4. Provides a short-cut to terminate a running query.
  5. Code Folding.
  6. Matched Brace/Bracket Highlighting.
  7. Parameter Tips.
  8. Zoom In/Out for SQL editors.
  9. SQL Beautifier.
  10. Favorites.
  11. Object Filter.
  12. Auto save in Query, Function etc.
  13. Custom sort in Tabler Viewer.
  14. Notification email supports SSL/TLS in Schedule.
  15. History Log Viewer.

Download here