# Multiple system.db.runUpdateQuery problem

**URL:** <https://forum.inductiveautomation.com/t/multiple-system-db-runupdatequery-problem/17681>\
**Category:** Ignition\
**Created:** [April 12, 2018, 7:15am UTC](https://forum.inductiveautomation.com/t/multiple-system-db-runupdatequery-problem/17681 "2018-04-12T07:15:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [April 12, 2018, 7:15am UTC](https://forum.inductiveautomation.com/t/multiple-system-db-runupdatequery-problem/17681/1 "2018-04-12T07:15:01Z")

</div>

I am registering data from a measurement line in sql, an event script gateway and I do not register one of the update query.

This is the script, is there something wrong?

```auto
from java.util import Date
if flanco == 0:
	now = Date() # creates a new date, for right now
	Fecha = system.db.dateFormat(now, "yyyy-MM-dd HH:mm:ss")
	Linea = "VDD"
	B1 = system.tag.getTagValue("VDD/B1")/1000
	B2 = system.tag.getTagValue("VDD/B2")/1000	
	B3 = system.tag.getTagValue("VDD/B3")/1000
	B4 = system.tag.getTagValue("VDD/B4")/1000
	B5 = system.tag.getTagValue("VDD/B5")/1000
	B6 = system.tag.getTagValue("VDD/B6")/1000
	P1 = system.tag.getTagValue("VDD/P1")/1000
	P2 = system.tag.getTagValue("VDD/P2")/1000
	B1B3 =system.tag.getTagValue("VDD/B1B3")/1000 # Control giro bisagra superior
	B4B6 = system.tag.getTagValue("VDD/B4B6")/1000 # Control giro bisagra inferior
	B2B1 = system.tag.getTagValue("VDD/B2B1")/1000 #Control paralelismo bisagra superior
	B5B4 = system.tag.getTagValue("VDD/B5B4")/1000 # Control paralelislo bisagra inferior
	flanco = system.tag.getTagValue("VDD/Flanco")
	
# ***************TOLERANCIAS**************
	P_MAX_B5_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_B5_B4")/1000
	P_MIN_B5_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_B5_B4")/1000
	G_MAX_B6_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MAX_B6_B4")/1000
	G_MIN_B6_B4 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MIN_B6_B4")/1000
	C_MAX_INF = system.tag.getTagValue("VDD/TOLERANCIAS/C_MAX_INF")/1000
	C_MIN_INF = system.tag.getTagValue("VDD/TOLERANCIAS/C_MIN_INF")/1000
	P_MAX_B2_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_B2_B1")/1000
	P_MIN_B2_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_B2_B1")/1000
	G_MAX_B3_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MAX_B3_B1")/1000
	G_MIN_B3_B1 = system.tag.getTagValue("VDD/TOLERANCIAS/G_MIN_B3_B1")/1000
	C_MAX_SUP = system.tag.getTagValue("VDD/TOLERANCIAS/C_MAX_SUP")/1000
	C_MIN_SUP = system.tag.getTagValue("VDD/TOLERANCIAS/C_MIN_SUP")/1000
	P_MAX_PUE = system.tag.getTagValue("VDD/TOLERANCIAS/P_MAX_PUE")/1000
	P_MIN_PUE = system.tag.getTagValue("VDD/TOLERANCIAS/P_MIN_PUE")/1000
# **********************************************************************************
# ************************************CONTAJE************************************

	system.db.runUpdateQuery ("INSERT INTO Bisagras (B1, B2, B3, B4, B5, B6, P1, P2, B1B3, B4B6, B2B1, B5B4, t_stamp, P_MAX_B5_B4, P_MIN_B5_B4, G_MAX_B6_B4, G_MIN_B6_B4, C_MAX_INF, C_MIN_INF, P_MAX_B2_B1, P_MIN_B2_B1, G_MAX_B3_B1, G_MIN_B3_B1, C_MAX_SUP, C_MIN_SUP, P_MAX_PUE, P_MIN_PUE, Linea) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" %(B1, B2, B3, B4, B5, B6, P1, P2, B1B3, B4B6, B2B1, B5B4, Fecha, P_MAX_B5_B4, P_MIN_B5_B4, G_MAX_B6_B4, G_MIN_B6_B4, C_MAX_INF, C_MIN_INF, P_MAX_B2_B1, P_MIN_B2_B1, G_MAX_B3_B1, G_MIN_B3_B1, C_MAX_SUP, C_MIN_SUP, P_MAX_PUE, P_MIN_PUE, Linea))
	PiezaOK = system.tag.getTagValue("VS20.VDD.MediciionBisagras.PiezaOK")
	PAMHabilitada = system.tag.getTagValue("VS20.VDD.MediciionBisagras.PiezaAtornilla MHabilitada")
	system.db.runUpdateQuery ("INSERT INTO B_contajes (t_stamp, Línea, PiezaOK, PAMHabilitada ) VALUES ('%s','%s','%s','%s')" %(Fecha, Linea, PiezaOK, PAMHabilitada))
	system.tag.writeToTag("VDD/Flanco", 1)	
	
	
else:
	system.tag.writeToTag("VDD/Flanco", 0)

```

---

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [April 12, 2018, 10:23am UTC](https://forum.inductiveautomation.com/t/multiple-system-db-runupdatequery-problem/17681/2 "2018-04-12T10:23:02Z")

</div>

Is the flanco tag, I consulted it without reading it. Now working well