Yeah I've read the docs, so I don't expect them to be unique, but I do expect them to be correct. By them not correct, I mean that in the database 4 does not exist yet 4 was returned.
Not using FTS3, just a "normal" table, everything works as expected. I don't know what you mean by "export". The insert is being executed with the Android SQLiteDatebase insert method. I don't have anything that updates the id and the id is incorrect at the point it was returned from the insert method. I have tested this on 2.1 and 2.3.1 and the same thing occurs. I am using the method as done in the Notepad sample where an empty row is inserted in the onCreate() method and then updates are done in onPause(). Curiously, I have not seen any other code that does this with FTS3. The SearchableDictionary sample does not care about the id. However, in this method having the correct id (so we can update the record) is pretty critical. On Feb 22, 8:12 pm, Bret Foreman <[email protected]> wrote: > According to my reading of the SQLite docs, the rowid is guaranteed to > be monotonically increasing but NOT sequential. And I would be > suspicious that your "export" is renumbering the rowids as part of the > export process. -- 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
