Re: [sqlite] checking if a record exist or not

Igor Tandetnik wrote... jose isaias cabrera wrote: 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

[sqlite] checking if a record exist or not

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';

Re: [sqlite] checking if a record exist or not

jose isaias cabrera cabr...@wrc.xerox.com wrote: 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

Re: [sqlite] checking if a record exist or not

On Thu, Mar 19, 2009 at 12:01 PM, jose isaias cabrera cabr...@wrc.xerox.com wrote: 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    

Re: [sqlite] checking if a record exist or not

Igor Tandetnik wrote... jose isaias cabrera wrote: 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

Re: [sqlite] checking if a record exist or not

P Kishor wrote On Thu, Mar 19, 2009 at 12:01 PM, jose isaias cabrera wrote: 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