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 <[email protected]> wrote: > Hi > Why do you think it should return error? > On Aug 2, 2013 1:15 AM, "techi eth" <[email protected]> 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
