Error trying to coerce value with system.dataset.setValue

[lrose]

As @Transistor hinted at, the type of column nitro_enable is numeric. So if you want to convert it you will need to either rebuild the dataset with the system.dataset.* functions, or the DatasetBuilder class.

For reference see:

Vision: Convert dataset column type

Use Ignition’s DatasetBuilder. Something like this: from com.inductiveautomation.ignition.common.util import DatasetBuilder from java.lang import Integer, String, Object from java.awt import Color def forceTypes(sqlDS): builder = DatasetBuilder.newBuilder() builder.colNames(sqlDS.columnNames) originalTypes = list(sqlDS.columnTypes) i = #some column index for a color originalTypes[i] = Color builder.colTypes(originalTypes) for r in range(sqlDS.rowCount): bui…