I'm sure about 'Id_' presence (it is used successfully in other saving operations close to UPDATE)
My doubt is about implicit sum: Gross=Gross+ integer_value this operation works fine for about 64 consecutive times and then I found a mismatch. It seems to be solved only by reducing the speed of open/close sequence (but is not an acceptable solution ...) Maybe have I to do an explicit sum by a SELECT + UPDATE? Thanks, Alessandro From: Kit <[email protected]> To: General Discussion of SQLite Database <[email protected]> Date: 06/03/2012 18.00 Subject: Re: [sqlite] UPDATE failure 2012/3/6 <[email protected]>: > UPDATE table_name SET IdDeptGroup=1, Gross=Gross+ integer_value WHERE > Id_= Id_value > > Have you ever seen a mismatch(sum is lower then expected) in the final sum > result ? Missing some `Id_` in the table? -- Kit _______________________________________________ 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
