Updating data in SQL with Power Table

Ignition
1

I am trying to use a Power Table to edit data in SQL. Where did I go wrong?

Index = self.data.getValueAt(rowIndex,0)
query = "UPDATE Production_Schedule_Table SET %s = ? WHERE Index = ?" % colName
system.db.runPrepUpdate(query,[newValue, Index],'13290_Statistics')
system.db.refresh(self.data)
2

You really shouldn't double-post. That just breaks up context and makes it hard to understand the question, like the fact that this is supposed to be an OnCellEdited event method.

Actual help is over on that topic.

1 Like