but... ...but I LOVE my hammer! How dare every problem not be a nail?
;) Good point. Likely all the updates can fit nicely into a transaction. On Mon, May 10, 2010 at 5:11 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 May 2010, at 9:25pm, Adam DeVita wrote: > > > Simon, can you expand your syntax, or are you just saying, "get x,y,z > store > > them in a set of variables, then run update with appropriate bindings"? > > Just that. You have a programming language with variables, so use it. > That's what your programming language is for. > > You might be able to get extremely clever and work out some contorted > SQLite syntax which will do the whole thing in one SQL command, but why > bother ? It'll be hell to work out what's wrong if you get an error > message. And it'll be difficult to document because you have to explain > your perverse syntax. Better to use two extremely simple SQL commands and > say "We get three values here ... then we use them in this UPDATE.". Faster > and simpler to write, debug and document. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users