Updating SQL Database via Powertable Entry 8.1.3

Ignition
1

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”)

2

MARKED AS SOLVED: After speaking to IA support, it was suggested to indent the entirety of the code block. That allowed the power table to updated as expected.