I insert the data using:
SQLiteStatement myStatement =
databaseWriter.compileStatement(statementString);
myStatement.executeInsert();
After Richards reply I went back and enclosed all these in try finally
blocks with myStatement.close(); now in the finally bracket. Guess I
missed one somewhere or one wasn't always being called because the
problem seems to have gone.
Thanks for the replies. (I'm off to hang my head in shame somewhere.)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users