HI, That sounds a neat solution, I'll have a look at implementing one. Many thanks. Dave
Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Petite Abeille Sent: 24 June 2014 21:57 To: General Discussion of SQLite Database Subject: Re: [sqlite] Sequential numbers On Jun 24, 2014, at 10:47 PM, Dave Wellman <dwell...@ward-analytics.com> wrote: > I need the values to be sequential. Well. if your data set is as small as you mentioned (20 records or less). you could roll your own numbering schema with the simple expedient of attaching a trigger to your tables to auto -number them with 'select count( * ) + 1 from table' or something. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users