Yes, I realize that. Not to mention it would take longer. I'll just query the rows current ROW_ID and pass it along.
The issue came up b/c when i do delete rows i get gaps. gaps were bad for my code :). I'm not sure I understand what a general transaction abort is. Is this something that happens often? On Nov 20, 1:46 pm, jotobjects <[email protected]> wrote: > 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
