1 files changed, 9 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java
index d496489d..5ba19c70 100644
--- a/dozentenmodulserver/src/main/java/sql/SQL.java
+++ b/dozentenmodulserver/src/main/java/sql/SQL.java
@@ -1390,11 +1390,18 @@ public class SQL {
 			//delete the lecture record
 			String sql = "DELETE FROM bwLehrpool.m_VLData_lecture WHERE lectureID = ?;";
 			PreparedStatement prest = con.prepareStatement(sql);
-			prest.setString(1, id);
+			prest.setString(1, id); 
 			
 			prest.executeUpdate();
 
-			//delete all permission records for this lecture		
+			
+			//delete all permission records for this lecture
+			sql = "DELETE FROM bwLehrpool.pm_VLData_lecture WHERE lectureID = ?;";
+			prest = con.prepareStatement(sql);
+			prest.setString(1, id); 
+			
+			prest.executeUpdate();
+			
 			con.commit();
 			con.close();
 			return true;