I am a JR .NET developer and have only a couple hours of basic Python training. I have been tasked with updating an existing py application. In the code snippit below I have added the green to the existing function. I have 2 questions. Does there look like any potential errors with my added snippet? And now that the change is made how to I push this to the executable? I am definitely more concerned with saving it to the exe. 
def additem(): results=msSQL.query("SELECT ID FROM TradePulse.dbo.chainauth WHERE ID='{0}';" .format(item_number_entry.get()+LocalDB.settings('chainid'))) ar = results[0] [color=#2ECC71]stmt= "SELECT DeletedItemV.Item FROM DeletedItemV LEFT OUTER JOIN ItemV ON (DeletedItemV.Item = ItemV.Item)WHERE ItemV.Item IS NULL"[/color] if len(ar) > 0: root = tk.Tk() root.withdraw() messagebox.showerror("Chain ID Error", 'Choose a different item number, the entered selected already exists.') [color=#27AE60] # if the item has been deleted and is not active in all warehouses do not allow to add if ar == stmt: root = tk.Tk() root.withdraw() messagebox.showerror("Item ID Error", 'Choose a different item number, the entered selected already has been cancelled.')[/color] if len(ar) == 0: chain=LocalDB.settings('chainid') item=item_number_entry.get() altcode=item_retail_entry.get() if altcode=='AltCode': altcode='' msSQL.queryExecute("INSERT TradePulse.dbo.chainauth (ITEM,CHIND,AltCode,ID) VALUES ({0},'{1}','{2}','{3}');" .format(item,chain,altcode,item+chain)) item_name_txt.set('Item#') item_retail_txt.set('AltCode') item_grid(itemQuery()) 