Hi, You expected the database to perform the assignment on each row WHERE ID = 2. It did exactly this.
-- kind regards - Roland Wilczek Am Freitag, 2. August 2013, 14:04:40 schrieb techi eth: > At the end of execution I am expecting SET will change the value but it > actually doesn't SET the value due to wrong condition. > > I will check return from sqlite3 & due to success return I am in wrong > assumption. > > On Fri, Aug 2, 2013 at 1:57 PM, Igor Korot <ikoro...@gmail.com> wrote: > > Hi > > Why do you think it should return error? > > > > On Aug 2, 2013 1:15 AM, "techi eth" <techi...@gmail.com> wrote: > > > Come across one issue with conditional query execution. > > > > > > Query: UPDATE COMPANY SET Name= 'test' WHERE ID = 2; > > > According to my understanding if no ID = 2 is present in table then > > > error > > > should return but it return with SQLITE_OK however Name value is not > > > changed. > > > > > > Cheers - > > > Techi > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- kind regards - Roland Wilczek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
