Hi Travis,
The code is getting to that point and beyond. I am not getting any errors. I had even set ip up to tell me if there was a problem with the window and it wpould come up as window not open.
[size=85]
#*******************************************************#
Routine Definitions
#*******************************************************#
1 - Box count
2 - Bag Count
def record(routine, lotNum):
import system
import app
from java.util import Date
#*******************************************************#
Variable Declaration Section
#*******************************************************#
lotNumber = ‘’
date = ‘’
operatorName = system.tag.getTagValue('[Client]Tracking/Current_Operator')
operatorId = system.tag.getTagValue('[Client]Tracking/Current_Operator_ID')
ingName = system.tag.getTagValue('[Client]Tracking/Selected_Ing')
qtyUsed = system.tag.getTagValue('[Client]Tracking/Select_Box_Count')
balanceQty = system.tag.getTagValue('[Client]Tracking/Balance_Qty')
recordId = system.tag.getTagValue('[Client]Tracking/Lot_RecordId')
now = Date()
ts = system.db.dateFormat(now, "HH:mm:ss") #database entry generation time
ds = system.db.dateFormat(now, "yyyy-MM-dd") #database entry generation date
date = ds + " " + ts
if routine == 1: #1 - Box count
system.db.runUpdateQuery("INSERT INTO Used_Lot_Numbers (Lot_Number, Date, Operator, Operator_ID, Ing_Name, Qty_Used, Qty_Balance) VALUES ( %d, '%s' , '%s', %d, '%s', %d, %d);" % (lotNum, date, operatorName, operatorId, ingName, qtyUsed, balanceQty), 'Mill_Tracking')
system.db.runUpdateQuery("UPDATE Lot_Numbers SET Qty_Balance = %d WHERE idLot = %d ;" % (balanceQty, recordId), 'Mill_Tracking')
system.db.runUpdateQuery("UPDATE Lot_Numbers SET Date_Modified = '%s' WHERE idLot = %d ;" % (date, recordId), 'Mill_Tracking')
system.nav.closeParentWindow('Popup_Box_Count')
system.tag.writeToTag('[Client]Tracking/Select_Box_Count',0)
system.tag.writeToTag('[Client]Tracking/Lot_Num_OK',0)
system.tag.writeToTag('[Client]Tracking/Select_Lockout',0)
system.tag.writeToTag('[Client]Tracking/Selected_Lot_Num',0)
app.Ingredient_Select_Control.Control(0)
[/size][/color]