Hi Petite, Many thanks fo rthsuggestion, it works a treat!. Hi Simon, Thanks for the thoughts but in this particular processing that is not going to happen (delete a few rows). In this processing we always empty the table completely before re-populating it.
I've gone with the TRIGGEr solution, it works really well. Many thanks to all. 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