You can use "FDConnection" option SQLiteAdvanced... to add some SQLite parametrization according with your SQLite DLL version... see on SQLite site about what's used!
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3
I'm not user of "SQLite" database, then, it's better study about it. OK? try on HELP from RAD Studio or on SQLite official site https://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC
you can use "BatchMove" to create a target table, instead a text file... as in my example:
---------- Note: you can use another fDQuery/Table/Dataset to insert the records-resulted directally! if you use another database, then, you can use another FDConnection + FDQuery to other database+table if you use same database (in and out) then, you need just another FDQuery to another table reference!
you can create a second table in your database or another database SQLite and use it as your "target" to "FDBatchMoveDataSetWriter1.Dataset = ???" ----------
using a FDMemtable for tests: FDBatchMoveDataSetReader1.Dataset = MyFDQuerySourceDatas FDBatchMoveDataSetWriter1.Dataset = MyFDMemtableTarget ... //FireDAC.Comp.BatchMove.TFDBatchMove.Execute if FDBatchMove.Execute > 0 then ... FDMemtable.SaveFile('myData.FDS');
FDMemtable.LoadFromFile('myData.FDS'); // fields = fields in FDQuerySource
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3