mORMot Open Source

noobies

Member

Registered: 2011-09-13

Posts: 139

combine 2 sqlite3 base

I have a few sqlite3 database that I need to integrate automatically in the program.
Using ADO I have done so

insert into secondbase select * from firstbase

How to make good use of this wonderful framework?

Last edited by noobies (2011-10-06 10:42:45)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: combine 2 sqlite3 base

If no primary key value is duplicated, you can safely use such SQL with our framework.

See http://www.sqlite.org/lang_insert.html

Use TSQLRestClient.EngineExecute() on the Client side for instance, to directly execute such SQL statements.

Or you can use an ORM-mapped loop, with a FillPrepare then BatchAdd (use Batch for better speed).
In this case, you'll have direct access to every column value (including the ID/RowID so you can make any needed change).