On Wed, 23 Jul 2014 20:00:52 -0600 "Keith Medcalf" <kmedc...@dessus.com> wrote:
> BEGIN; > INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects as A > WHERE A.ProjID <= 133560 AND > Date != A.Date AND > A.login = 'user1'; > END; > > I presume that LSOpenProjects in both databases has a unique > constraint on ProjID, Date, and login ... That BEGIN/END should be superfluous because INSERT...SELECT is a single atomic statement. Is there something about SQLite that makes it necessary, or was it just for illustrative purposes? --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users