I am trying to update a SQL table when edits are made within a power table using the onCellEdited extension function. I cannot get the following code or any attempted modifications to work. selectedID is a custom property that is functioning correctly. I am running 7.8.0. Thank you!
ID = event.source.selectedID
query = “UPDATE temp_budget SET line_item = ? WHERE ID = ?”
values = [newValue, ID]
system.db.runPrepUpdate(query, values, “IgnitionDefault”)