"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 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. > > > José, you didn't communicate the above very well, because the above > sentence makes no sense whatsoever. If you are still in a transaction > and delete something that you didn't mean to, you can always bring it > back by not committing the transaction.
Yes, I am kinda new. Heck, I am a newbie and I may not have communicated the correct situation. Never mind, it does work. My fault. I got scared, because I built this system counting on INSERT OR REPLACE to work was the words describe. Thanks guys. False alarm. My apologies. josé _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
