PowerTable onCellEdited script isnt updating the sql database

[dpace]

# Example
    #self.data = system.dataset.setValue(self.data, rowIndex, colIndex, newValue)
    ndx = self.data.getValueAt(rowIndex, 'Formula')
    
    query = "UPDATE BL1Formulas SET %s = ? WHERE Formula = ?" % (colName)
    
    system.db.runPrepUpdate(BL1Formulas, [value,ndx],'Kens_OT')
    
    system.db.refresh(self.data)

[dkhayes117]

First step is to debug the query itself and check the gateway for error messages. Print the query, the args, and their types.

# use system.perspective.print() instead of print() if using perspective.
print query
print 'value:{}, type:{}'.format(value,type(value))
print 'ndx:{}, type:{}'.format(ndx,type(ndx))

[MMaynard]

@dpace

system.db.runPrepUpdate(BL1Formulas, [value,ndx],'Kens_OT')

That should probably be

@dpace

system.db.runPrepUpdate(BL1Formulas, [newValue,ndx],'Kens_OT')

Value isn’t a valid pointer in onCellEdited