I have a scripting for a vision table to edit the cell, here is the scripting
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
In most of my client it works well, when I click the cell, I can change the data just like excel
But one of my computer when I click 1 cell, the data will be cleared as emtpy.
Anyone have these kind of experience?
