[sqlite] Removes hole's in ROWID

[Alexey Yutkin]

Hi,

I have a table 'myData'. 

I insert 10 records into 'myData'.
Now ROWID's = 1,2,3,4,5,6,7,8,9,10

I delete record where ROWID=5  in 'myData' table.
Now ROWID's = 1,2,3,4,6,7,8,9,10

ROWID column have a 'hole' at 5.
How I can reindex column ROWID, like this:
ROWID's = 1,2,3,4,5,6,7,8,9

Thanks a lot,
Alexey.




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]