The error message i am getting:
File “event:mousePressed”, line 43, in
Thermoplastics.dbo.PartTracking
set
Thermoplastics.dbo.PartTracking = 97
from
Thermoplastics.dbo.PartTracking
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.PartTracking.Container
where Thermoplastics.dbo.FinishingResults.CureLot = 160309072124, , , false)
java.lang.Exception: java.lang.Exception: Error executing system.db.runUpdateQuery(update
Thermoplastics.dbo.PartTracking
set
Thermoplastics.dbo.PartTracking = 97
from
Thermoplastics.dbo.PartTracking
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.PartTracking.Container
where Thermoplastics.dbo.FinishingResults.CureLot = 160309072124, , , false)
caused by Exception: Error executing system.db.runUpdateQuery(update
Thermoplastics.dbo.PartTracking
set
Thermoplastics.dbo.PartTracking = 97
from
Thermoplastics.dbo.PartTracking
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.PartTracking.Container
where Thermoplastics.dbo.FinishingResults.CureLot = 160309072124, , , false)
caused by GatewayException: SQL error for "update
Thermoplastics.dbo.PartTracking
set
Thermoplastics.dbo.PartTracking = 97
from
Thermoplastics.dbo.PartTracking
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.PartTracking.Container
where Thermoplastics.dbo.FinishingResults.CureLot = 160309072124": The multi-part identifier "Thermoplastics.dbo.PartTracking" could not be bound.
caused by SQLServerException: The multi-part identifier "Thermoplastics.dbo.PartTracking" could not be bound.
Based off this code
[code]import time
qv1 = event.source.parent.getComponent(‘Label 15’).text
qv2 = system.tag.read(“Finishing/OP97/CureLot”)
if system.gui.confirm(u’Are you sure?’, ‘Confirm’):
sql = “”“update
Thermoplastics.dbo.FinishingResults
set
Thermoplastics.dbo.FinishingResults.BushingContainer = Thermoplastics.dbo.Curelot.BushingsContainer,
Thermoplastics.dbo.FinishingResults.AdhesiveContainer = Thermoplastics.dbo.Curelot.AdhesiveContainer,
Thermoplastics.dbo.FinishingResults.CureLot = Thermoplastics.dbo.Curelot.CureLot
from
Thermoplastics.dbo.CureLot
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.CureLot.Container”""
system.db.runUpdateQuery(sql)
#time.sleep(1)
sql1 = """delete from
Thermoplastics.dbo.Curelot
where
CureLot = (%s)""" %(qv1)
system.db.runUpdateQuery(sql1)
sql2 = """update
Thermoplastics.dbo.PartTracking
set
Thermoplastics.dbo.PartTracking = 97
from
Thermoplastics.dbo.PartTracking
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.PartTracking.Container
where Thermoplastics.dbo.FinishingResults.CureLot = """+qv1+""""""
system.db.runUpdateQuery(sql2)[/code]