On 7 Nov 2010, at 6:14pm, cricketfan wrote: > Just to make things clearer > the value being fetched into ref from the database, is also the value being > changed(ghi) in the update statement. When I change my query (just to debug) > to update some other column in the table the whole thing runs fine and runs > only once! > Can someone throw some light on this?
I don't understand why you find this surprising. You have two pieces of program: one is trying to look at something while the other is in the middle of changing it. They are going to argue about which one can access those values. You can complete the scan first, then make the changes you want. Or if the changes depend on the scan, use an UPDATE ... WHERE command that does all the work for you. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users