I have some code here that lets the user drag and drop data from one power table to the next:
if system.gui.confirm("Are you sure you want to scrap this part?", "Recycle?"): if self != sourceTable: destDataset = self.getData() pyRowData = system.dataset.toPyDataSet(rowData) for row in pyRowData: newRow =  for column in row: newRow.append(column) destDataset = system.dataset.addRow(destDataset, dropIndexLocation, newRow) self.setData(destDataset) system.db.runPrepQuery("DELETE FROM my_Table WHERE RFID = ?;", [destDataset.getValueAt(0,0)]) sourceTable = results else: system.gui.messageBox("Dropping on to same table not supported")
However it seems that no matter what syntax I try the sql table is never actually updated. Does anyone know what my runPrepQuery is missing?