Re: [sqlite] UPDATE failure

2012-03-07 Thread A . Azzolini
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 To: General Discussion of SQLite Database Date: 06/03/2012 18.00 Subject: Re: [sqlite] UPDATE failure 2012/3/6 : > UPD

Re: [sqlite] UPDATE failure

2012-03-06 Thread Kit
2012/3/6 : > 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 maili

[sqlite] UPDATE failure

2012-03-06 Thread A . Azzolini
Hallo, I'm working with SQLite rel.3.4.3. on embedded system with ARM processor (unfortunately I cannot use a more recent release due to customizations on source code) I need to update a db of statistics very often, opening and closing db handle many times, with a short delay between each upd