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

Reply via email to