I use a do/while that runs through one of my tables based on the
number of entries on another table and makes changes.

Example:

Integer i = 1;

Cursor c = db.querryFunction();
Integer rowCount = c.getCount();

do{
    //does work on the database
    db.updateRow(table, args, KEY_ROWID + "=" + i, null);
    i++;
}
while(i <= rowCount);


if my autoincrements skips numbers then I can get an error trying to
update a row that doesn't exist.


On Nov 20, 8:47 am, Mark Murphy <mmur...@commonsware.com> wrote:
> JasonMP wrote:
> > I need my rows in my
> > database to stay ascending and in increments of 1.
>
> Why?
>
> --
> Mark Murphy (a Commons 
> Guy)http://commonsware.com|http://twitter.com/commonsguy
>
> Warescription: Three Android Books, Plus Updates, $35/Year

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to