# SQL Insert Issues **URL:** \ **Category:** Ignition\ **Created:** [May 2, 2018, 11:46am UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897 "2018-05-02T11:46:46Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![keith.hyder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keith.hyder/32/4909_2.png) [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Post date:** [May 2, 2018, 11:46am UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/1 "2018-05-02T11:46:46Z")
Good Morning, I am trying to do a SQL Insert through Scripting. I have it set on the Action performed of a button. Unfortunately I can’t seem to get it to work. Here is the script I have in place: ```auto PO = "CT/Variables/PO Number" Model = "CT/Variables/Model Number" PL = "[Client]Production Line" St = "[Client]Station" Min = "5" DT = "123456" Query = "INSERT INTO Ign_CT_PauseRecords (PONumber, ModelNumber, ProductionLine, Station, Minutes, DateTime) VALUES (?, ?, ?, ?, ?, ?)" args = [PO, Model, PL, St, Min, DT] system.db.runPrepUpdate(Query, args) ``` Each Time I run the application i just get a huge list of error details I can’t understand. ```auto 07:31:39.330 [AWT-EventQueue-2] ERROR com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter - Error executing script for event: actionPerformed
on component: Button. com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most recent call last): File "", line 16, in java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO Ign_CT_PauseRecords (PONumber, ModelNumber, ProductionLine, Station, Minutes, DateTime) VALUES (?, ?, ?, ?, ?, ?), [CT/Variables/PO Number, CT/Variables/Model Number, [Client]Production Line, [Client]Station, 5, 123456], , , false, false) ``` Any assistance would be greatly appreciated, and thank you in advance. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 2, 2018, 11:57am UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/2 "2018-05-02T11:57:48Z")
On the error popup, please select full details, and cut and paste the entire exception here. (Use triple-back-tick quotes on lines before and after the text so it’ll format nicely.) In the meantime, I’m going to make an educated guess: you are expecting the strings containing tag paths to be converted to values, and you wan’t those values to be inserted, not the strings. But jython doesn’t magically know those strings are tag paths – it’s expecting those columns in your DB to be varchar or text types. You need a call to [system.tag.read\*()](https://docs.inductiveautomation.com/display/DOC79/system.tag.readAll) to request the values for those tag paths, and put the QV.value variables in your insert call. ---
**Author:** ![keith.hyder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keith.hyder/32/4909_2.png) [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Post date:** [May 2, 2018, 1:06pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/3 "2018-05-02T13:06:49Z")
I got the tag values using the system.tag.read. I used the print command to verify the variables values. ```auto PO = system.tag.read("CT/Variables/PO Number") #Corrected Model = system.tag.read("CT/Variables/Model Number") #Corrected PL = system.tag.read("[Client]Production Line") #Corrected St = system.tag.read("[Client]Station") #Corrected Min = "5" DT = "123456" #print(PO) #print(Model) #print(PL) #print(St) #print(Min) #print(DT) Query = "INSERT INTO Ign_CT_PauseRecords (PONumber, ModelNumber, ProductionLine, Station, Minutes, DateTime) VALUES (?, ?, ?, ?, ?, ?)" args = [PO, Model, PL, St, Min, DT] print(Query,args) system.db.runPrepUpdate(Query,args) ``` I have found a flaw I still don’t know how to get around. PL = system.tag.read("[Client]Production Line") This returns the Tag Value, Quality, and Time Stamp. Then it tries to put it in my query as such: **TC Bath, Good, Mon Apr 30 08:51:55 EDT 2018** My SQL table can’t handle that. All I want to get for a variable is the Value “TC Bath” Any Ideas on this one? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 2, 2018, 1:27pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/4 "2018-05-02T13:27:11Z")
system.tag.read and system.tag.readAll return qualified values, not just the data point itself. Please take a closer look at the documentation I linked. You should have something like this: ```auto PL = system.tag.read("[Client]Production Line").value ``` Also, please edit your comment so your code has triple-backquotes on a line before and on a line after, so it is readable. ---
**Author:** ![keith.hyder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keith.hyder/32/4909_2.png) [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Post date:** [May 2, 2018, 1:31pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/5 "2018-05-02T13:31:59Z")
Working Good. Thank you for you time and help. I do appreciate it. ---
**Author:** ![keith.hyder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keith.hyder/32/4909_2.png) [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Post date:** [May 2, 2018, 1:37pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/6 "2018-05-02T13:37:09Z")
Is this what you mean by the triple-back-quotes? ```auto PO = system.tag.read("CT/Variables/PO Number").value Mod = system.tag.read("CT/Variables/Model Number").value PL = system.tag.read("[Client]Production Line").value St = system.tag.read("[Client]Station").value Min = "5" DT = "123446" ``` ---
**Author:** ![keith.hyder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/keith.hyder/32/4909_2.png) [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Post date:** [May 2, 2018, 1:37pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/7 "2018-05-02T13:37:36Z")
Ahhhh I see what it does. Thanks again for all you help. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 2, 2018, 1:39pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897/8 "2018-05-02T13:39:48Z")
You can edit your earlier comments to make them neat with the triple-backquotes, too.