[sqlite] checking if a record exist or not

[jose isaias cabrera]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users