JasonMP wrote: > I'm very new to all of this so I greatly appreciate your advice. But > to clarify, you mean instead of using AUTOINCREMENT i create a column > to hold an integer value that I set, and can therefore control rather > than let SQLite do it automatically?
You could do that. Or, you let AUTOINCREMENT do its thing and make no assumptions about what specific values the primary keys have, just that they are unique. So, rather than iterating over integer values that you hope are the right set of keys, you actually get the keys and iterate over said keys. Or, better yet, see if you can update all of the rows in a single UPDATE statement. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://twitter.com/commonsguy Android Development Wiki: http://wiki.andmob.org -- 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
