SQLite Can I use a DOT command in a TQuery statement?
lazarus / 16-Databases

----------------------------------------------------------------------
Middlecope · 2023-06-24 12:50

I like to import a CSV file into a table.
In SQLite3 it is easily done with .import
Can I use a query to execute that command or should I use an external
program
and integrate it in my code with TProcess?
Thanks for your attention

----------------------------------------------------------------------
paweld · 2023-06-24 14:12

The .import command is only available in the sqlite tool.
But in Lazarus you can also easily import data from a csv file - the
attachment contains an example.

----------------------------------------------------------------------
jcmontherock · 2023-06-24 14:38

Unfortunately your example does not compile (win64 / FPC 322 / 226 /
64) !....

----------------------------------------------------------------------
paweld · 2023-06-24 14:44

ahh, sorry. I am using lazarus trunk and there new data types were
introduced. I removed the redundant types and now it is ok. Download
the attachment again

----------------------------------------------------------------------
Middlecope · 2023-06-24 18:52

Thank you "paweld"
I am not so quick. This weekend I will give it a try
Thanks

----------------------------------------------------------------------
jcmontherock · 2023-06-25 08:55

Thanks Paweld, I just ad a "tran.commit" in Form.Destroy and a
"tran.StartTransaction" in Form.Create procedure. It works fine.