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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
