Is this thing working? I posted a couple times now and nothing has showed up.
On Feb 22, 9:12 am, Joe <[email protected]> wrote: > I am experiencing an incorrect rowid value with sqlite and fts3. > > Basically, the first two rows are inserted and the rowId is 1 and 2 > respectively. The third insert however returns 4 instead of 3. > > I dropped the following log message in my contentprovider when > inserting a row: > > SQLiteDatabase database = > databaseHelper.getWritableDatabase(); > long rowId = database.insert(NOTES_TABLE, Note.NOTE, values); > Log.d("NoteProvider", "RowId inserted was " + rowId); > > The output of that log message is: > > 02-21 21:10:12.773: DEBUG/NoteProvider(2486): RowId inserted was 1 > 02-21 21:10:20.623: DEBUG/NoteProvider(2486): RowId inserted was 2 > 02-21 21:10:25.883: DEBUG/NoteProvider(2486): RowId inserted was 4 > > So what happened to 3? > > Also, I exported the sqlite database so I could look at in a SqLite > browser and the content table shows 1, 2 and 3. > > So 3 was created but 4 was returned. > > I ran my testing up to 10, and the rowId was sequential afterwards, > but still off by 1. > > The database create script is: > > database.execSQL("CREATE VIRTUAL TABLE " + NOTES_TABLE + " > USING fts3 (" > + Note.TITLE + ", " > + Note.NOTE + ", " > + Note.CREATED_DATE + ", " > + Note.MODIFIED_DATE + ");"); > > I am assuming I have done something horribly wrong, but cannot figure > out what it is. > Can anyone help me out? > > ** This is a repost of my question on > stackoverflow.http://stackoverflow.com/questions/5078788/incorrect-rowid-with-sqlit... -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
