On Wed, 24 Sep 2014 20:51:38 +0200 RSmith <rsm...@rsweb.co.za> wrote:
> I was thinking in stead of maybe having a prev and next column, to > just have a next column which points to an ID. ... > ID | Next | Data > 1 | 4 | 'First Row' > 2 | 3 | 'Eventual Fourth Row' > 3 | 1 | 'Last Row' > 4 | 5 | 'New Second Row' > 5 | 2 | 'New Third Row' The first question I'd have is: Where are the ordering criteria, and why aren't they in the database? Someone is imposing an order, but the basis for it is not included in the database design. You're generating information instead of recording it. Include that information, and the problem is converted to nonproblem. HTH. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
