DELETE FROM `MATERIALS` WHERE ((`MA_NR` = ?) AND ((? = 1 AND `MA_NAME` IS NULL) OR (`MA_NAME` = ?)) AND ((? = 1 AND `MA_DESCR` IS NULL) OR (`MA_DESCR` = ?)) AND ((? = 1 AND `MA_INDEX` IS NULL) OR (`MA_INDEX` = ?))) INSERT INTO `MATERIALS` (`MA_NAME`, `MA_DESCR`, `MA_INDEX`) VALUES (?, ?, ?) SELECT MA_NR, MA_NAME, MA_DESCR, MA_INDEX FROM MATERIALS UPDATE `MATERIALS` SET `MA_NAME` = ?, `MA_DESCR` = ?, `MA_INDEX` = ? WHERE ((`MA_NR` = ?) AND ((? = 1 AND `MA_NAME` IS NULL) OR (`MA_NAME` = ?)) AND ((? = 1 AND `MA_DESCR` IS NULL) OR (`MA_DESCR` = ?)) AND ((? = 1 AND `MA_INDEX` IS NULL) OR (`MA_INDEX` = ?))) DELETE FROM `PARAMETERVALUES` WHERE ((`PV_NR` = ?) AND ((? = 1 AND `MA_NR` IS NULL) OR (`MA_NR` = ?)) AND ((? = 1 AND `PN_NR` IS NULL) OR (`PN_NR` = ?)) AND ((? = 1 AND `PV_VALUE` IS NULL) OR (`PV_VALUE` = ?))) INSERT INTO `PARAMETERVALUES` (`MA_NR`, `PN_NR`, `PV_VALUE`) VALUES (?, ?, ?) SELECT PV_NR, MA_NR, PN_NR, PV_VALUE FROM PARAMETERVALUES UPDATE `PARAMETERVALUES` SET `MA_NR` = ?, `PN_NR` = ?, `PV_VALUE` = ? WHERE ((`PV_NR` = ?) AND ((? = 1 AND `MA_NR` IS NULL) OR (`MA_NR` = ?)) AND ((? = 1 AND `PN_NR` IS NULL) OR (`PN_NR` = ?)) AND ((? = 1 AND `PV_VALUE` IS NULL) OR (`PV_VALUE` = ?))) DELETE FROM `PARAMETERNAMES` WHERE ((`PN_NR` = ?) AND ((? = 1 AND `PN_NAME` IS NULL) OR (`PN_NAME` = ?))) INSERT INTO `PARAMETERNAMES` (`PN_NAME`) VALUES (?) SELECT PN_NR, PN_NAME FROM PARAMETERNAMES UPDATE `PARAMETERNAMES` SET `PN_NAME` = ? WHERE ((`PN_NR` = ?) AND ((? = 1 AND `PN_NAME` IS NULL) OR (`PN_NAME` = ?)))