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 <[email protected]> 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 [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
