![]() I have patched my trigger so I can go forward. It's a student with enrollments and no grades (and still no GPA entry) that I can not delete. If I could not delete a new student with no enrollments (and no GPA entry) then I would understand the constraint violation, but I can delete that student. The conflict occurred in database "", table "dbo.GPA", column 'StudentID'. The DELETE statement conflicted with the REFERENCE constraint "FK_dbo.GPA_dbo.Student_StudentID". But I can not delete a student with enrollments but no grades (#2). I can delete a student with enrollments and grades (#3 above). I can delete a student with no enrollments (#1). If a student has grades it will update or insert an entry into the GPA table no grades, no GPA table entry. There is a trigger on the enrollments table to calculate GPA. A student with enrollments but no grades.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |