Mercurial > bmsapp / file diff

--- a/src/EditProduct.cpp	Mon Jan 23 17:23:10 2023 +0100
+++ b/src/EditProduct.cpp	Tue Jan 24 15:57:13 2023 +0100
@@ -912,6 +912,19 @@
     if (rc == QMessageBox::No)
         return;
 
+    /*
+     * First delete any pictures for this product.
+     */
+    QSqlQuery query;
+    query.prepare("DELETE FROM products_pics WHERE uuid=:uuid");
+    query.bindValue(":uuid", product->uuid);
+    query.exec();
+    if (query.lastError().isValid()) {
+        qWarning() << "on_deleteButton_clicked()" << query.lastError();
+        QMessageBox::warning(this, tr("Database error"), tr("MySQL error: %1\n%2\n%3")
+                .arg(query.lastError().nativeErrorCode()).arg(query.lastError().driverText()).arg(query.lastError().databaseText()));
+    }
+
     DB_product::dele(this, this->recno);
 
     this->close();