[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] rowid increment
From:       Chris Peachment <cpeachment () caribsurf ! com>
Date:       2008-10-29 17:00:12
Message-ID: 1225299612.5583.57.camel () davinci
[Download RAW message or body]

Use an autoincrement field in the table instead.

On Wed, 2008-10-29 at 09:46 -0700, Shaun R. wrote:
> The rowid looks to reuse numbers when a row is deleted, how can i stop this?
> 
> For example, i insert 3 rows, then i delete row 2, when entering a new row 
> after that the rowid is 2 rather than 4.   I want the rowid to be 4.
> 
> ~Shaun 
> 
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]