Pavel Ivanov willingly and out of the goodness of his heart wrote:
> If the following can be considered as one step then do it like this: > > BEGIN; > UPDATE LSOpenSubProjects > SET price = (SELECT sum(price) FROM table1 WHERE subProjID = 24), > udate = now > WHERE subProjID = 24; > UPDATE LSOpenProjects > SET price = (SELECT sum(price) FROM table2 WHERE ProjID = 8), > udate = now > WHERE ProjID = 8; > END; It is one step for me. :-) Thanks. I wish I had written to the list without spending two hours trying to write this. Thanks. josé > > On Wed, Jul 21, 2010 at 2:28 PM, jose isaias cabrera > <cabr...@wrc.xerox.com> wrote: >> >> Greetings and salutations. >> >> I believe this is possible, but I can not seem to get the syntax from the >> site. I have these 3 commands and 3 different steps that I want to put >> into >> one: >> >> 1. result1 = SELECT sum(price) FROM table1 WHERE subProjID = 24; >> 2. result2 = SELECT sum(price) FROM table2 WHERE ProjID = 8; >> 3. BEGIN; >> UPDATE LSOpenSubProjects SET price = result1 WHERE subProjID = 24; >> UPDATE LSOpenSubProjects SET udate = now WHERE subProjID = 24; >> UPDATE LSOpenProjects SET price = result2 WHERE ProjID = 8; >> UPDATE LSOpenProjects SET udate = now WHERE ProjID = 8; >> END; >> >> How can I put all of these 3 steps into one? >> >> 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
