TSqlite3Dataset, insert
lazarus / 16-Databases

----------------------------------------------------------------------
mrdebug · 2008-07-10 08:08

How can I put a large number of lines in a short time in a table?

With DBIsam I can run:
Code: [Select]
DBISAMQDatiLocale.SQL.Text: =   'insert into Table (Number, Name)
values (''1'', ''Denis'');
                                                                insert
into Table (Number, Name) values (''2'', ''David'');';


DBIsam works perfectly.
TSqlite3Dataset but inserts only the first line.

----------------------------------------------------------------------
LuizAmérico · 2008-07-12 18:50

Use SqlList property instead and call ExecSqlList
To get better performance put BEGIN; as the first statement and
COMMIT; as the last.

----------------------------------------------------------------------
mrdebug · 2008-07-12 19:40

Thanks 1000!