Hi, CREATE TABLE Parent( ParentId INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT, PRIMARY KEY (ParentId));CREATE TABLE Child( ChildId
INTEGER PRIMARY KEY AUTOINCREMENT, ParentId INT, name TEXT, PRIMARY
KEY(ChildId), FOREIGN KEY(ParentId) REFERENCES Parent(ParentId));after
insert into Parent values('name1'); how to get parentId and set the parentId in
table Child.Thanks,
Zeal.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
