On 10/14/2016 9:29 AM, Thom Wharton wrote:
ID        Date                       Type     Size  Data

1        10OCT-08:13:47      Ether    28    sddsgsd...

2        10OCT-08:13:52      Ether    77    fdasfdsdsddssdg...

3        10OCT-08:13:52      Ether    44    zeasfkkfa...

4        10OCT-08:13:57      Ether    33    dartdg...

5        10OCT-08:14:03      Ether    51    afafsfafa...

I want to be able to programmatically insert a new record anywhere in
that table.  Let's suppose I want to create a new record between the
records whose ID are 2 and 3.

Why? Is there some indicator you haven't told us about that suggests the new record should go between 2 and 3? If so, make that indicator part of the row data, and use it in your ordering to break ties between timestamps. It makes no sense to use RowId for that.
Igor Tandetnik

sqlite-users mailing list

Reply via email to