Greetings...
I am updating an sqlite db from another sqlite db and it is working fine,
unless the record does not exists. ie.
"ATTACH db2 AS client; ";
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
SELECT * FROM client.LSOpenJobs
WHERE login='x' AND XtraB > '2000';
COMMIT;
this works fine if the record already exists in the db getting updated.
However, if the record was deleted, inadvertively, from the db getting
updated, this will not work.
Is there a way to insert the record back in the db getting updated if it is
not there? You should know that this record did exists previously in this
db, but it was deleted.
This is the CREATE table schema:
CREATE TABLE LSOpenJobs
(
id integer primary key,
ProjID integer,
login,
...,
XtraB,
XtraC,
XtraD,
XtraE,
XtraF
);
Thanks for the help,
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
