On Oct 20, 2008, at 5:38 PM, jm cuaz wrote: > Hello, > > We try to port an application specialised in financial calculus > written > in VBA + MS Access toward Tcl + Sqlite. > > In this application, 90% of the calculus is directly processed at the > SQL level via INSERT/UPDATE statements executed against the db, and > subsets are calculated with INNER JOINS between the tables inside each > statement. > In consequence, our statements are easily dealing with 3/4 tables (not > rarely more) at once. > > But in this purpose, we encounter a severe issue in the fact that in > Sqlite, UPDATE statements, in the contrary of INSERT statements, > doesn't compute several tables at once. > > On this mailing list, Igor Tandetnik (thank's Igor) showed us a > workaround via subqueries inserted in the FROM and WHERE clauses of > UPDATE statements. > > But, while not impossible, it is difficult to do so when the number of > tables involved is greater than 3. > > Ticket 3222 had still made a request in this direction. > > Does anybody kows if there is any plan for enhancing Sqlite's UPDATE > statement in this direction ?
As far as I know there is no such plan. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
