El 14/10/16 a les 15:29, Thom Wharton ha escrit:

I have a table of records in a Sqlite DB.  It contains 5 records. Each
record has a time-stamp which is not guaranteed to be unique.  To
preserve order (which is important in my project), I've given the table
an integer primary key (called ID) that is auto-increment.

Instead of an autoincrement you could increment it manually in, say, 1000 increments. Then, when you have to insert something between 1000 and 2000 you just use 1500.

Luca Olivetti
Wetron Automation Technology http://www.wetron.es/
Tel. +34 93 5883004 (Ext.3010)  Fax +34 93 5883007
sqlite-users mailing list

Reply via email to