On Nov 20, 6:04 am, JasonMP <[email protected]> wrote: > > if my autoincrements skips numbers then I can get an error trying to > update a row that doesn't exist. >
What if you delete a row later? That will cause a gap. Are you sure that will never happen? In general transaction aborts may result in rows that were created but not inserted so there are gaps from that. You are going to pay a performance penalty for trying to create your own auto incrementing keys, assuming you can get it to work at all. -- 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
