Hello. We currently have a process that we're wanting to move into Ignition where we register our part numbers for any new numbers that come through to my company. It's not uncommon for there to be 40 new part numbers issued to a sales order at one time. I'm designing a window with multiple text boxes for part numbers, customer part numbers, descriptions and other relevant data. The part number, customer part number, description 1 and description 2 are unique to each part number and the rest of the data is redundant as it applies to a single customer. I've made a window and wrote this script to a button and it's failing:
q1 = event.source.parent.getComponent('q1').text
q2 = event.source.parent.getComponent('q2').text
q3 = event.source.parent.getComponent('q3').text
q4 = event.source.parent.getComponent('q4').text
q5 = event.source.parent.getComponent('q5').text
q6 = event.source.parent.getComponent('q6').text
q7 = event.source.parent.getComponent('q7').text
q8 = event.source.parent.getComponent('q8').text
q9 = event.source.parent.getComponent('q9').text
q10 = event.source.parent.getComponent('q10').textc1 = event.source.parent.getComponent('c1').text
c2 = event.source.parent.getComponent('c2').text
c3 = event.source.parent.getComponent('c3').text
c4 = event.source.parent.getComponent('c4').text
c5 = event.source.parent.getComponent('c5').text
c6 = event.source.parent.getComponent('c6').text
c7 = event.source.parent.getComponent('c7').text
c8 = event.source.parent.getComponent('c8').text
c9 = event.source.parent.getComponent('c9').text
c10 = event.source.parent.getComponent('c10').textda1 = event.source.parent.getComponent('da1').text
da2 = event.source.parent.getComponent('da2').text
da3 = event.source.parent.getComponent('da3').text
da4 = event.source.parent.getComponent('da4').text
da5 = event.source.parent.getComponent('da5').text
da6 = event.source.parent.getComponent('da6').text
da7 = event.source.parent.getComponent('da7').text
da8 = event.source.parent.getComponent('da8').text
da9 = event.source.parent.getComponent('da9').text
da10 = event.source.parent.getComponent('da10').textdb1 = event.source.parent.getComponent('db1').text
db2 = event.source.parent.getComponent('db2').text
db3 = event.source.parent.getComponent('db3').text
db4 = event.source.parent.getComponent('db4').text
db5 = event.source.parent.getComponent('db5').text
db6 = event.source.parent.getComponent('db6').text
db7 = event.source.parent.getComponent('db7').text
db8 = event.source.parent.getComponent('db8').text
db9 = event.source.parent.getComponent('db9').text
db10 = event.source.parent.getComponent('db10').textum =event.source.parent.getComponent('um').text
pl =event.source.parent.getComponent('pl').selectedStringValue
pro =event.source.parent.getComponent('prg').selectedStringValue
it =event.source.parent.getComponent('it').selectedStringValue
st =event.source.parent.getComponent('sta').selectedStringValue
gr =event.source.parent.getComponent('grp').selectedStringValue
rc =event.source.parent.getComponent('rtg').selectedStringValue
abc =event.source.parent.getComponent('abc').selectedStringValue
si = '1000'
loc =event.source.parent.getComponent('loc').selectedStringValue
pm =event.source.parent.getComponent('pm').selectedStringValue
comm = event.source.parent.getComponent('cmt').text
un =[System]Client/User/Username.Value
system.db.runPrepUpdate("INSERT INTO Part_registration (QAD_pn,Customer_pn,Desc1,Desc2,UM,Pline,Program,Itype,Status,Group,Rcode,ABC,Site,Location,PM,Comments,Username)
VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
",[
q1,c1,da1,db1,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q2,c2,da2,db2,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q3,c3,da3,db3,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q4,c4,da4,db4,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q5,c5,da5,db5,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q6,c6,da6,db6,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q7,c7,da7,db7,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q8,c8,da8,db8,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q9,c9,da9,db9,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un,
q10,c10,da10,db10,um,pl,pro,it,st,gr,rc,abc,si,loc,pm,comm,un
])
This is the Error message I get when I try to apply it:
Parse error for event handler "mouseClicked" SyntaxError: ("no viable alternative at character '?'", (' ', 60, 1, '(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),\n'))
I have no idea where it's getting the 60 and the 1...and I'm lost. I realize it's ugly but it's the best way I could figure out to do it. If anyone has a suggestion on a script fix, or a better way to do it I'm all ears. Any help would be greatly appreciated! Thank you!