> CREATE TRIGGER countOfTypesInabc AFTER INSERT ON abc > BEGIN > UPDATE countOfTypesInabc SET count = count+1 WHERE TypeID = > new.TypeID; > END
I understand now what you meant - yes, that makes sense and is probably the easiest way to go. > You will have to add something for creating records in the table > countOfTypesInabc if they don't already exist, but I'll leave that to > you to work out. Yes, of course - that's all done. Thank you, Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
