# Power Table OnCellEdited

**URL:** <https://forum.inductiveautomation.com/t/power-table-oncelledited/10737>\
**Category:** General Discussion\
**Created:** [November 4, 2015, 5:04pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledited/10737 "2015-11-04T17:04:50Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![nlanc97](https://avatars.discourse-cdn.com/v4/letter/n/c0e974/32.png) [@nlanc97](https://forum.inductiveautomation.com/u/nlanc97)\
**Post date:** [September 24, 2019, 1:17pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledited/10737/9 "2019-09-24T13:17:41Z")

</div>

Any tips on what I have done wrong?

```auto
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)

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/power-table-oncelledited/10737)._