# Ignition database

**URL:** <https://forum.inductiveautomation.com/t/ignition-database/40679>\
**Category:** Ignition\
**Tags:** scripting, database, ignition80\
**Created:** [November 16, 2020, 2:48am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679 "2020-11-16T02:48:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![epifanio.tigno](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\
**Post date:** [November 16, 2020, 2:48am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679/1 "2020-11-16T02:48:42Z")

</div>

Hi, is it possible to have and INSERT INTO SELECT STATEMENT in ignition?  
how about its syntax in scripting?

---

<div class="post-metadata">

**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:** [November 16, 2020, 2:55am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679/2 "2020-11-16T02:55:11Z")

</div>

It is a perfectly acceptable query for system.db.runPrepUpdate() or any of the other update query forms. (“Update” includes “Insert” as far as JDBC is concerned.)

---

<div class="post-metadata">

**Author:** ![epifanio.tigno](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\
**Post date:** [November 16, 2020, 2:59am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679/3 "2020-11-16T02:59:01Z")

</div>

I have an sql statement that goes like this  
INSERT INTO rp\_transformation\_slip(item\_code2,item\_desc2,scan\_code,cat1,cat2,item\_code1,item\_desc1,weight\_origin,total\_crates,no\_crates\_from,total\_weight,no\_print,slip\_series\_no)  
select distinct item\_code2,item\_desc2,scan\_code,cat1,cat2,item\_code1,item\_desc1,weight\_origin,sum(no\_crates\_tr)as total\_crates,no\_crates\_from,sum(weight)as total,‘2’,‘TS-00001’

from transaction\_to where scan\_code = ‘2002316’  
group by item\_code2,item\_desc2,scan\_code,cat1,cat2,item\_code1,item\_code2,item\_desc1,weight\_origin,no\_crates\_tr,no\_crates\_from

how do i contruct a syntax that dynamically passed the paramaters from a text field of scan code ?

---

<div class="post-metadata">

**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:** [November 16, 2020, 3:09am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679/4 "2020-11-16T03:09:38Z")

</div>

For [runPrepUpdate](https://docs.inductiveautomation.com/display/DOC80/system.db.runPrepUpdate), place a un-quoted question mark where the quoted constant would be in your query, and supply the value in the list of args. Syntax would be a bit different for named queries, as they take a dictionary instead of a list. I recommend keeping the manual open in a browser tab while working on new scripts.

---

<div class="post-metadata">

**Author:** ![epifanio.tigno](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\
**Post date:** [November 17, 2020, 5:08am UTC](https://forum.inductiveautomation.com/t/ignition-database/40679/5 "2020-11-17T05:08:56Z")

</div>

Thank you so much