[android-developers] Re: SQLite does not write inserts but does not raise error neither

I answer to myself: there seems that there is nothing wrong with the
function itself, but with some other code inherited from previous
version where a file was used to store scores, that cleans the array and
it is saved in the database through other function used to import old
data from files to the DB.

I have solved it yet.

Best regards,


On 26/06/12 13:16, Francisco M. Marzoa Alonso wrote:
> Hi there,
>
> I have a function to write scores in an SQL database table. Here is the
> code:
>
> public void setScores(int scores[]) {
> int len = (scores.length > 10) ? 10 : scores.length;
> SQLiteDatabase db = this.getWritableDatabase();
> db.beginTransaction();
> db.delete("scores", null, null);
> ContentValues values = new ContentValues();
> int score = 0;
> for (int i=0; i<len; i++) {
> score = scores[i];
> values.put("score", score);
> db.insert("scores", null, values);
> }
> db.setTransactionSuccessful();
> db.endTransaction();
> db.close();
> }
>
> I have checked with Eclipse debugger that scores[] array does actually
> carries the scores when the function is called and even values different
> from 0 are assigned on values.put("score", score), but when loading the
> table later they are not there. O_o
>
> This is the function call that creates that table:
>
> db.execSQL("CREATE TABLE scores (score UNSIGNED INTEGER)");
>
> It is called only when the database does not exists within the onCreate
> event on an SQLiteOpenHelper derived class, so it should be created when
> the inserts are performed.
>
> I do not get any error from SQLite when doing the transaction, so I am
> really lost with this.
>
> I have other tables and I perform other inserts and transactions on the
> same database and those works fine.
>
> May be there is something wrong with my code that I have not noticed
> yet. It is my first attempt to use an SQLite database within an Android app.
>
> Thanks a lot in advance,
>


--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en