MS SQL Queries Adding Table Columns

[dkhayes117]

Not sure about the query, but I can link you to a post where I did something similar.

Compact Table Scripting and Add IF statement to columnData.append

Looks much nicer than my rep rep repetitiveness ha ha. I got this code to work and initialize all Booleans to 0. Your code threw an error…TypeError: can’t put element of type class java.lang.Booleanin column of type class java.lang.Integer po = event.source.value data = system.db.runNamedQuery("BOM/PoDetails",{"po":po}) fields = ['5x5', '4x8', 'RB', 'HW'] for field in fields: columnData = [] for row in range(data.getRowCount()): ##description = data.getValueAt(row, "Description")## This…