[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    kdenonbeta/krecipes/src/DBBackend
From:       Unai Garro <Unai.Garro () ee ! ed ! ac ! uk>
Date:       2003-09-19 12:30:34
[Download RAW message or body]

CVS commit by uga: 

While removing categories, remove those categories from recipes too


  M +3 -0      literecipedb.cpp   1.37
  M +3 -0      mysqlrecipedb.cpp   1.18


--- kdenonbeta/krecipes/src/DBBackend/literecipedb.cpp  #1.36:1.37
@@ -1190,4 +1190,7 @@ QString command;
 command=QString("DELETE FROM categories WHERE id=%1;").arg(categoryID);
 database->executeQuery(command);
+
+command=QString("DELETE FROM category_list WHERE category_id=%1;").arg(categoryID);
+database->executeQuery(command);
 }
 

--- kdenonbeta/krecipes/src/DBBackend/mysqlrecipedb.cpp  #1.17:1.18
@@ -1153,4 +1153,7 @@ QString command;
 command=QString("DELETE FROM categories WHERE id=%1;").arg(categoryID);
 QSqlQuery categoryToRemove( command,database);
+
+command=QString("DELETE FROM category_list WHERE category_id=%1;").arg(categoryID);
+categoryToRemove.exec(command);
 }
 


[prev in list] [next in list] [prev in thread] [next in thread]