Hi,
this is not really a Basic4android question. I get this error randomly, in a service, so that debugging is difficult.
It happens during an update table statement, but I think 99 statements out of 100 work.
I just would like to know if any of you has encountered such an edrror and what he/she did about it.
What version of Android is this? An old one? I think there used to be issues with SQLite on older versions.
I would also check the Open Cursor and Close Cursor statements and that you begin and end transactions where appropriate.
ETA : More recent versions of Android are a little more tolerant of the issue. As klaus has indicated it could be a memory issue, which may appear to be random, but may well be just down to the difference in the memory available at the various times. Closing Cursors should stop the memory being used up too quickly.