Ok. That is what I am doing now. Every so often, it fails, for some reason. It could be a network problem, but I don't think so. Anyway, thanks for the help.
josé ----- Original Message ----- From: "Martin Engelschalk" <engelsch...@codeswift.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, March 02, 2009 1:14 PM Subject: Re: [sqlite] INSERTing OR REPLACEing Together or one at a time > Hi, > > it seems to me that between LSOpenProjects and LSOpenSubProjects you > have a 1:n relationship, and also between LSOpenSubProjects and > LSOpenJobs. > Also, it seems that you want to copy data from an attached database "c" > to the main database. > So, if you want to preserve this relationship in your main database, you > have to use one transaction, Command #2, and rollback in case of failure. > > Martin > > jose isaias cabrera wrote: >> Greetings. >> >> which command is safer to use: >> >> Command #1: >> >> BEGIN; >> INSERT OR REPLACE INTO LSOpenProjects >> SELECT * FROM c.LSOpenProjects >> WHERE ProjID = 2000; >> COMMIT; >> BEGIN; >> INSERT OR REPLACE INTO LSOpenSubProjects >> SELECT * FROM c.LSOpenSubProjects >> WHERE ProjID = 2000; >> COMMIT; >> BEGIN; >> INSERT OR REPLACE INTO LSOpenJobs >> SELECT * FROM c.LSOpenJobs >> WHERE ProjID = 2000; >> COMMIT; >> >> >> Command #2: >> >> BEGIN; >> INSERT OR REPLACE INTO LSOpenProjects >> SELECT * FROM c.LSOpenProjects >> WHERE ProjID = 2000; >> INSERT OR REPLACE INTO LSOpenSubProjects >> SELECT * FROM c.LSOpenSubProjects >> WHERE ProjID = 2000; >> INSERT OR REPLACE INTO LSOpenJobs >> SELECT * FROM c.LSOpenJobs >> WHERE ProjID = 2000; >> COMMIT; >> >> This latter one is failing every so often. But, it should not matter >> much, >> since it is writing to three different tables. I should say that there >> is >> always, just one LSOpenProject record; at least, one LSOpenSubProjects >> records and, at least, one LSOpenJobs record. But 99% of the time, there >> is >> always more than one LSOpenJobs. >> >> Any ideas? >> >> thanks, >> >> josé >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
