Differences

This shows you the differences between two versions of the page.

--- wiki:sqlitespy:index [2021/03/01 11:37] – Answer "no auto-save on exit" feature suggestion admin
+++ wiki:sqlitespy:index [2021/03/27 13:23] (current) – admin
@@ Line 6: / Line 6: @@
 ===== Delphi Components used in SQLiteSpy =====
-  * Unicode support is realized Delphi's native Unicode controls (formerly [[products:tntunicodecontrols:|Tnt Unicode Controls]]).
   * Data grid and the schema treeview are implemented as [[https://github.com/Virtual-TreeView/Virtual-TreeView/|TVirtualStringTree]] descendants.
   * Modern tabs are displayed by JVCL TJvTabBar (formerly with added Unicode support).
   * [[https://github.com/SynEdit/SynEdit|SynEdit]] (formerly UniSynEdit) and a customized SQLite3 highlighter bring SQL Unicode syntax highlighting to SQLiteSpy.
 ===== Feature Suggestions =====
@@ Line 21: / Line 19: @@
   * Support of "INSTEAD OF" triggers in views, to allow cell editing (F2) of corresponding view columns
-  * CSV export and import.
+  * CSV import and export:
+    * For CSV import, use the [[https://sqlite.org/csv.html|CSV extension]]. Example: <code sql>
+CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv');
+SELECT * FROM t1;
+</code>
+    * CSV export is not yet supported. The clipboard can be a workaround: Select rows, copy, and paste into a spreadsheet application.
   * Create / Modify / Delete Tables by Wizard