Fixed select yeasts in recipes and poducts.

Sun, 19 Jun 2022 13:34:18 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 19 Jun 2022 13:34:18 +0200
changeset 299
8021e09ab6a3
parent 298
180c77a81e15
child 300
2a97905cb637

Fixed select yeasts in recipes and poducts.

CMakeLists.txt file | annotate | diff | comparison | revisions
src/EditProductTab6.cpp file | annotate | diff | comparison | revisions
src/EditRecipeTab5.cpp file | annotate | diff | comparison | revisions
--- a/CMakeLists.txt	Sun Jun 19 11:56:02 2022 +0200
+++ b/CMakeLists.txt	Sun Jun 19 13:34:18 2022 +0200
@@ -9,7 +9,7 @@
 
 SET( bmsapp_VERSION_MAJOR 0 )
 SET( bmsapp_VERSION_MINOR 2 )
-SET( bmsapp_VERSION_PATCH 10 )
+SET( bmsapp_VERSION_PATCH 11 )
 
 # Compile flags
 
--- a/src/EditProductTab6.cpp	Sun Jun 19 11:56:02 2022 +0200
+++ b/src/EditProductTab6.cpp	Sun Jun 19 13:34:18 2022 +0200
@@ -769,7 +769,7 @@
      */
     QString sql = "SELECT name,laboratory,product_id,type,form,min_temperature,max_temperature,flocculation,attenuation,"
 	          "cells,tolerance,sta1,bacteria,harvest_top,harvest_time,pitch_temperature,pofpos,zymocide,"
-		  "gr_hl_lo,sg_lo,gr_hl_hi,sg_hi,cost,inventory FROM inventoryeasts ";
+		  "gr_hl_lo,sg_lo,gr_hl_hi,sg_hi,cost,inventory FROM inventory_yeasts ";
     if (instock)
         sql.append("WHERE inventory > 0 ");
     sql.append("ORDER BY laboratory,product_id,name");
@@ -886,7 +886,7 @@
 
     this->yselectEdit->setCurrentIndex(-1);
     this->yselectEdit->clear();
-    QString sql = "SELECT name,laboratory,product_id,inventory FROM inventoryeasts ";
+    QString sql = "SELECT name,laboratory,product_id,inventory FROM inventory_yeasts ";
     if (val)
         sql.append("WHERE inventory > 0 ");
     sql.append("ORDER BY laboratory,product_id,name");
--- a/src/EditRecipeTab5.cpp	Sun Jun 19 11:56:02 2022 +0200
+++ b/src/EditRecipeTab5.cpp	Sun Jun 19 13:34:18 2022 +0200
@@ -310,7 +310,7 @@
      */
     QString sql = "SELECT name,laboratory,product_id,type,form,min_temperature,max_temperature,flocculation,attenuation,"
 	          "cells,tolerance,sta1,bacteria,harvest_top,harvest_time,pitch_temperature,pofpos,zymocide,"
-		  "gr_hl_lo,sg_lo,gr_hl_hi,sg_hi,cost FROM inventoryeasts ";
+		  "gr_hl_lo,sg_lo,gr_hl_hi,sg_hi,cost FROM inventory_yeasts ";
     if (instock)
         sql.append("WHERE inventory > 0 ");
     sql.append("ORDER BY laboratory,product_id,name");
@@ -406,7 +406,7 @@
 
     this->yselectEdit->setCurrentIndex(-1);
     this->yselectEdit->clear();
-    QString sql = "SELECT name,laboratory,product_id,inventory FROM inventoryeasts ";
+    QString sql = "SELECT name,laboratory,product_id,inventory FROM inventory_yeasts ";
     if (val)
         sql.append("WHERE inventory > 0 ");
     sql.append("ORDER BY laboratory,product_id,name");

mercurial