On Sat, 8 Aug 2009 12:59:53 +0100, Simon Slavin
<[email protected]> wrote:
>Not to start from zero that way. But you can create a record yourself
>which has a barcode of
>
>1000000001
>
>to force the number of digits, and from then SQLite will count up from
>that one. (Test this first, I haven't tried exactly that.)
Thanks guys, it worked. For those interested (Delphi):
========
SQL.Clear;
SQL.Add('CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY,
label VARCHAR)');
ExecSQL;
SQL.Clear;
SQL.Add('INSERT INTO mytable (id,label) VALUES (100001,"my label");');
SQL.Add('INSERT INTO mytable (label) VALUES ("my label2")');
ExecSQL;
========
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
