On Sun, 7 Nov 2010 10:14:29 -0800 (PST), cricketfan <srtedul...@yahoo.co.in> 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? It is still unclear to me why you insist using a cursor. A single UPDATE statement with a proper WHERE clause should do the job. I already suggested code for that. Since your first example wasn't exact, and the second is not complete I'm not really tempted to look into it. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
