Hence the suggestion to script a transaction. For example, in pseudocode:
BEGIN;
SELECT value, increment from super_sequences where table = :table and column =
:column;
INSERT INTO :table (id, other, fields) VALUES :(value+increment,other,values);
UPDATE super_sequences set value = :(value + increment) WHERE table = :table
and column = :column;
COMMIT;
On 8/2/17, 10:37 AM, "sqlite-users on behalf of Sylvain Pointeau"
<sqlite-users-boun...@mailinglists.sqlite.org on behalf of
sylvain.point...@gmail.com> wrote:
On Wed, Aug 2, 2017 at 5:27 PM, Peter Da Silva <
peter.dasi...@flightaware.com> wrote:
> Have a look at https://sqlite.org/autoinc.html
>
Yes I am aware of autoinc but this is not what I can use, because I need to
specify exactly the sequence (as start number and increment). Additionally
I can have tables having 2 or 3 fields needing a specified sequence number.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
