Sprezzatura FAQ Pages

If you want to delete a COURSE_MASTER record then it may not always be enough just to type DELETE COURSE_MASTER COURSENUM at TCL.

The reason for this is something called "Referential Integrity". What this means is that if any other record on the system refers to this record it may prevent this record being deleted. So if you've deleted a COURSE_MASTER record and it comes back then you may need to take the following steps.

Go to TCL and type the following

FormList course_master CourseNumber Appoints_Rel

if you now get a message saying "No rows present" then ignore the next step

if you get some records selected then

Delete Mod_Appoints

Now

FormList course_master CourseNumber Progress_Rel

if you now get a message saying "No rows present" then ignore the next step

if you get some records selected then

Delete Progress_Temp

NOW you can delete the Course_Master row!

Delete Course_Master CourseNum

What is TCL?

Jargon busters!

Click here to return to the main FAQs page