# Vision PowerTable table edit abnormal

**URL:** <https://forum.inductiveautomation.com/t/vision-powertable-table-edit-abnormal/57497>\
**Category:** Ignition\
**Tags:** vision, scripting\
**Created:** [March 23, 2022, 6:28am UTC](https://forum.inductiveautomation.com/t/vision-powertable-table-edit-abnormal/57497 "2022-03-23T06:28:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [March 23, 2022, 6:28am UTC](https://forum.inductiveautomation.com/t/vision-powertable-table-edit-abnormal/57497/1 "2022-03-23T06:28:19Z")

</div>

I have a scripting for a vision table to edit the cell, here is the scripting

```auto
	id = self.data.getValueAt(rowIndex, 'id')
		
	query = "UPDATE [dbo].[NTSplice_DATA] SET %s = ? WHERE [id] = ?" % (colName)
	args = [newValue, id]
	system.db.runPrepUpdate(query, args, 'NTSplicingSCADA')
	system.db.refresh(self, "data")

```

here is the runtime version  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/8/a84955d073f1fe73f52e81723ac5cfb060322716.png)  
In most of my client it works well, when I click the cell, I can change the data just like excel

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/a/2a224c7fe25dd6b3d5ebba69ee9ee9ba5a8fd349.png)

But one of my computer when I click 1 cell, the data will be cleared as emtpy.  
Anyone have these kind of experience?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/e/ce0b4d3e8b1fd8420ce1b2fc97eba8caefb2d7a0.png)