On 2 Dec 2010, at 7:38pm, cricketfan wrote:
> {
> Select a from tbl1 where b='yyy' c ='xxx' limit i offset (i + 1) ;
> Update tbl1 set e=1 where a = some value from the select;
> i = i + 1
> }
There doesn't appear to be any purpose to anything but the UPDATE command. Can
you not do all the dating with a single UPDATE command that has a less specific
WHERE clause ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
