WebSite Professional Server Self Test

DeleteClass Query

Robert B. Denny (18-Nov-95)
Database View
Used delete a class, by name. This query contains a parameter [pClass], the name of the class to delete. Referential integrity assures that all StudentsAndClasses records for this class will get deleted automatically.
PARAMETERS pClass Text;
DELETE DISTINCTROW Classes.*, Classes.ClassName
FROM Classes
WHERE ((Classes.ClassName=[pClass]));


WebSite Tech Support