Re: [sqlite] Updating records from a SELECT that exists in the table

How about this? BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT cl.* FROM client.LSOpenProjects cl JOIN LSOpenProjects ls ON (cl.ProjID = ls.ProjID AND cl.ProjID <= 133560 AND cl.XtraB >= '2014-08-07 00:00:00';); END; I used join query to get existing records in local DB instead of

Re: [sqlite] archive of database

Simon, Tony, Thank you very mucj r your answer! It was helpful. All the best! 73 de HA5OGL -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org