SQLite Forum

.dot commands long queries equivalent

.dot commands long queries equivalent

(1) By Ppro6 (Chanda) on 2020-04-22 10:42:24 [link] [source]

Good day, I would like some assistance with complete queries for .dot commands. These are to be used in API calls to the SQlite3.dll. I am especially interested in .export and .import csv or other files. The background of my request is that .dot commands only work in the sqlite3 console.

(2) By Gunter Hick (gunter_hick) on 2020-04-22 11:45:07 in reply to 1 [source]

The dot commands are features of the SQLite Shell and are not included in the SQLite3.dll. You need to run the SQLite Shell in a subprocess (connected via pipes on unix) to use them.

(3) By Ppro6 (Chanda) on 2020-04-23 06:07:35 in reply to 2 [link] [source]

Thank you. I am using windows 10. You have given me an idea of what to do, the functions I am looking for are available as extensions of the library so I will try sqlite3_load_extension() function.