How to use SQlite without prop:sql

[CarlBarnes]

There is the SQLite3.Exe Command Line Shell

sqlite> .headers on
sqlite> .mode csv
sqlite> .once c:/work/dataout.csv
sqlite> SELECT * FROM tab1;
sqlite> .system c:/work/dataout.csv

https://sqlite.org/cli.html

I posted about here

How to import CSV into Clarion 11 TopSpeed file without writing code

SQLite offers an easy way to create a DB Table from CSV with its SQLite3.Exe tool. You get from SQLite.org. Search the web for “SQLite Import CSV” for many tutorials You run SQLite3.exe and issue these Dot commands [image] The fields all end up as TEXT which Clarion DCT Import defines as STRING(20). That tool has a lot of options so I may have missed something. They are ways to configure delimiters, quotes and EOL. [image] Now you have an SQLite file you can import into TPS.