Re: [sqlite] Regenerating ROWID...?

2007-08-31 Thread Babu, Lokesh
Thanks Simon, Time being I was looking for the same. Thanks again for the help. On 8/31/07, Simon Davies <[EMAIL PROTECTED]> wrote: > On 31/08/2007, Babu, Lokesh <[EMAIL PROTECTED]> wrote: > > I was trying the following piece of code (see below), > > > > The requirement here is very simple, I

Re: [sqlite] Regenerating ROWID...?

2007-08-31 Thread Simon Davies
On 31/08/2007, Babu, Lokesh <[EMAIL PROTECTED]> wrote: > I was trying the following piece of code (see below), > > The requirement here is very simple, I want the t_id field or ROWID > field to be regenerated sequentially even after delete has been > performed. > Hi Lokesh, You can achieve this

[sqlite] Regenerating ROWID...?

2007-08-31 Thread Babu, Lokesh
I was trying the following piece of code (see below), The requirement here is very simple, I want the t_id field or ROWID field to be regenerated sequentially even after delete has been performed. In the below code, I have created a table with 3 fields, Inserted 1000 records, Deleted some middle