Mihai Limbasan <[EMAIL PROTECTED]> wrote: >> Igor Tandetnik wrote: >>> You can't make this happen automatically with SQLite. > >> Hmm? Of course you can. Just use a trigger: >> http://sqlite.org/lang_createtrigger.html
Can you show an example of a trigger that would make these statements work: insert into snapshot (bumf) values ('one'); insert into sample(type, used) values ('a', 1); insert into sample(type, used) values ('b', 1); so that, at the end, the two new records in sample table would have snapshotid equal to snapshot.id from the record inserted into snapshot table. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users