Im trying to edite a cell with booleans in a power table and change the data in the database this is my script in the extension functions of onCellEdited:
Row = self.data.getValueAt(rowIndex, 'Row')
query = "UPDATE Actividades SET %s = ? WHERE Row = ?" % (colName)
args = [bool(newValue), Row]
system.db.runPrepUpdate(query, args)
system.db.refresh(self, "data")
and this is the issue:
The line you're looking for is,
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException:
SQL error for UPDATE Actividades.Machine_ledger SET Check = ? WHERE Row = ?":
Incorrect syntax near the keyword 'Check'.
(I had to use OCR to extract the error message so there may be errors in it. Tip: post text - not pictures of errors or code. When posting code format it properly. See link below.)
It looks like you are expecting a column 'Check' but the database doesn't have one.