I have had success updating a table via a standard table but when I try to do it on a Power Table I never get the data to update. Is the following code correct? “numID” is the autogenerated row ID of each entry.
Entered under CellEdited Extension functions (as shown here: Updating the Database through the Power Table - Ignition User Manual 8.1 - Ignition Documentation )
key=self.data.getValueAt(rowIndex, “numID”)
query = “UPDATE tbl_EastSSLADowntime SET %s = ? WHERE NumID = ?” % (colName)
args = [newValue, key]
system.db.runPrepUpdate(query, args)
system.db.refresh(self, “data”)