1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE [Table1] ([Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[Val001] TEXT NULL);
CREATE TABLE [TABLE2] ([INB] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[VAL02] INTEGER NOT NULL, --Référence vers table1 sur le RowId
[VAL03] TEXT NULL) ;
BEGIN TRANSACTION;
INSERT INTO TABLE1 (val001) VALUES ('Test');
insert into table2 (val02, val03) values (last_insert_rowid(),'Test');
INSERT INTO TABLE1 (val001) VALUES ('Test1');
insert into table2 (val02, val03) values (last_insert_rowid(),'Test1');
INSERT INTO TABLE1 (val001) VALUES ('Test2');
insert into table2 (val02, val03) values (last_insert_rowid(),'Test2');
INSERT INTO TABLE1 (val001) VALUES ('Test3');
insert into table2 (val02, val03) values (last_insert_rowid(),'Test3');
commit; |
Partager