> Most you need to know about locking is found in: > http://www.sqlite.org/lang_transaction.html > > sqlite3_exec() these statements one by one: > ATTACH 'filename' as db2; > BEGIN IMMEDIATE; -- or EXCLUSIVE > (error handling/retry) > > -- this assumes table1 has the exact > -- same definition in both db1 and db2 > INSERT INTO db1.table1 SELECT * FROM db2.table1; > (error handling) > > COMMIT; -- or ROLLBACK
Ok, good... Thanks a lot for this quick structure! Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users