Good day all,
This is a snippett of a bigger script. Can you tell me why I would be getting an error saying SuperName is not defined?
EndsDownRQD = system.tag.readBlocking(tagPathEndsDownRQD)[0].value
Line = i
tStamp = system.date.now()
Shift = system.tag.readBlocking("[default]Twisters/Current Shift")[0].value
if Shift == "J":
SuperName = "1-32 Carol Brookeshire, 33-65 Lind Smith"
if Shift == "K":
SuperName = "1-32 Andrew Frazier, 33-65 Tracy Presley"
if Shift == "L":
SuperName = "1-32 Sandra McIntyre, 33-65 Tim Foley"
if Shift == "M":
SuperName = "1-32 Juanita Gordon, 33-65 Jan Kelly"
#######ComponentNum
system.db.runPrepUpdate("INSERT INTO Plt65_Twister_Production (tStamp, Line, Shift, RunTimeR, RunTimeL, LotNumR, LotNumL, BOCountRQD, BOCountRQC, BOCountR, BOCountLQB,BOCountLQA, BOCountL, MeterLenR, MeterLenL, TotShiftTimeR, TotShiftTimeL, DenierR, DenierL, LBSProdRQD, LBSProdRQC, LBSProdR, LBSProdLQB, LBSProdLQA, LBSProdL, MachineNum, EffRQD, EffRQC, EffR, EffLQB, EffLQA, EffL, DTperBreakRQD, DTperBreakRQC, DTperBreakR, DTperBreakLQB, DTperBreakLQA, DTperBreakL, DT, EndsDown, EndsDownLQA, EndsDownLQB, EndsDownRQC, EndsDownRQD, SuperName) Values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",[tStamp, Line, Shift, RunTimeR, RunTimeL, LotNumR, LotNumL, BOCountRQD, BOCountRQC, BOCountR, BOCountLQB,BOCountLQA, BOCountL, MeterLenR, MeterLenL, TotShiftTimeR, TotShiftTimeL, DenierR, DenierL, LBSProdRQD, LBSProdRQC, LBSProdR, LBSProdLQB, LBSProdLQA, LBSProdL, MachineNum, EffRQD, EffRQC, EffR, EffLQB, EffLQA, EffL, DTperBreakRQD, DTperBreakRQC, DTperBreakR, DTperBreakLQB, DTperBreakLQA, DTperBreakL, DT, EndsDown, EndsDownLQA, EndsDownLQB, EndsDownRQC, EndsDownRQD, SuperName])