Is there a way of doing that in one single shot : UPDATE Contacts SET Age = 30 WHERE ID = 1; UPDATE Contacts SET Age = 30 WHERE ID = 2; UPDATE Contacts SET Age = 20 WHERE ID = 3; UPDATE Contacts SET Age = 10 WHERE ID = 4;
I knwo I can process one a the time, but I would like to know why my query is not working if I build it and separate them with a semicolon.... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users