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 box…

Use a multiline string (triple single or double quotes) to format your SQL properly - assuming you copied and pasted into the forum verbatim, the issue is the dangling line breaks in your query. system.db.runPrepUpdate("""INSERT INTO Part_registration (QAD_pn,Customer_pn,Desc1,Desc2,UM,Pline,Pr…

I don’t know if this helps but this is what my designer shows: Image

It is verbatim, so should I move the bracket down to the values level? Sorry I’m very rough on scripting.

Sorry - I edited my post; the issue’s not the square bracket but just the multiline nature of your query. It should work fine as long as you switch to """ instead of " around the entire query.

Oh, you also need to read the system tag containing the username, not attempt to reference it directly: un = system.tag.read("[System]Client/User/Username.Value").value

You can eliminate a lot of the duplicate using some python concepts like list comprehensions: (disclaimer: untested) from itertools import chain qs = [event.source.parent.getComponent("q" + i) for i in range(1, 11)] cs = [event.source.parent.getComponent("c" + i) for i in range(1, 11)] das = [eve…

This got me thank you very much for your help!

Inductive Automation Forum

Scripting Issue trying to input a bunch of rows of data into SQL

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled