diff -r 94b3def5d778 -r 8a25dbe682eb src/EditYeastPack.cpp --- a/src/EditYeastPack.cpp Mon Jan 30 17:05:13 2023 +0100 +++ b/src/EditYeastPack.cpp Tue Jan 31 11:10:14 2023 +0100 @@ -122,11 +122,11 @@ if (this->recno == -1) { query.prepare("INSERT INTO inventory_yeastpack SET laboratory=:laboratory, form=:form, " "package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, " - "size=:size, used='0', uuid = :uuid"); + "size=:size, used='0', valid='1', uuid = :uuid"); } else { query.prepare("UPDATE inventory_yeastpack SET laboratory=:laboratory, form=:form, " "package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, " - "size=:size WHERE record = :recno"); + "size=:size, valid='1' WHERE record = :recno"); } query.bindValue(":laboratory", ui->laboratoryEdit->text()); query.bindValue(":form", ui->formEdit->currentIndex()); @@ -165,7 +165,7 @@ QSqlQuery query; query.prepare("INSERT INTO inventory_yeastpack SET laboratory=:laboratory, form=:form, " "package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, " - "size=:size, used=:used, uuid=:uuid"); + "size=:size, used=:used, valid='0', uuid=:uuid"); query.bindValue(":laboratory", ui->laboratoryEdit->text()); query.bindValue(":form", ui->formEdit->currentIndex()); query.bindValue(":package", ui->packageEdit->text() + " [copy]");