On 29 May 2012, at 1:16am, IQuant <[email protected]> wrote: > I may try a 2 pass approach: Pass 1 update query to record the rowid > of the previous symbol record and pass 2 use a join for performing the > IQ calcs.
Yep. Just do it in your programming language. One SELECT to find the previous symbol records, then UPDATES. That's what programming language are for. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

