This gives me the old syntax error. (on the last line)
[quote]# get new value
value = event.newValue
get row for new value (local table)
row = event.row
get column for new value in local table
col = event.column
get selected column name for db update
data = event.source.data
colname = data.getColumnName(col)
get ID for database update
IDnum = data.getValueAt(row,“ID”)
#change DB to reflect edited table
system.db.runPrepUpdate(“UPDATE stimprogram SET ?=? WHERE ID=?”,[colname,value,IDnum], “CHCFG”[/quote]