Hello all,
Is it possible to create such an AFTER INSERT trigger that updates certain
fields in a table based on the actual data being inserted?
Let's say:
CREATE TABLE abc(TypeID INTEGER)
CREATE TABLE abcCount(TypeCountA, TypeCountB)
CREATE TRIGGER CountTypeA AFTER INSERT ON abc /* when abc.TypeID == 1 */ BEGIN
UPDATE abcCount SET TypeCountA=TypeCountA+1; END
CREATE TRIGGER CountTypeB AFTER INSERT ON abc /* when abc.TypeID == 2 */ BEGIN
UPDATE abcCount SET TypeCountB=TypeCountB+1; END
Is something like that possible? I couldn't find any syntax construct I could
put in place of the comment.
Thanks in advance,
Dennis
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
