how to add a sqlite trigger?
Posted on 2010-11-16
I'm trying to add a sqlite trigger to my android database. I have 2 tables:
CourseGrade(courseId, courseName, courseGrade)
What I would like is when an insert is done on Courses, I would like to setup a trigger to insert courseId, and courseName into CourseGrade table. Also when I delete a course from Courses table I would like to delete it from the courseGrade table. Is this possible?