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.
sqlite-users mailing list