helllo I am having trouble with some sqlite coding. I am trying to update values for an item inside a database.
the code to update the database is called from another file here is the code.
def UpdateItem(self):
name1 = self.ItemIDLabelLineEdit.text()
name2 = self.ItemCostLineEdit.text()
name3 = self.ItemPriceLineEdit.text()
name4 = self.ItemReOrderLineEdit.text()
name5 = self.ItemDescriptionLineEdit.text()
name6 = self.ItemStockLevelLineEdit.text()
name7 = self.ItemMinimumStockLevelLineEdit.text()
name8 = self.ItemNameLineEdit.text()
print(name1)
print(name2)
print(name3)
print(name4)
print(name5)
print(name6)
print(name7)
print(name8)
SqlData.ItemUpdate(name1, name2, name3, name4, name5, name6, name7, name8)
in the second file the code is this
class ItemUpdate(object):
def __init__(self, name1, name2, name3, name4, name5, name6, name7, name8):
print(name1)
print(name2)
print(name3)
print(name4)
print(name5)
print(name6)
print(name7)
print(name8)
cursor.execute("""UPDATE Items_Table SET Item_Name = """+name8+""", Item_Description = """+name5+""", Item_Price = """+name3+""", Item_Cost = """+name2+""", Item_Stock_Level = """+name6+""", Item_ReOderLevel = """+name4+""", Item_Minimum_Stock_Level = """+name7+""" WHERE Item_ID == """+name1+"""""")
db.commit()
cursor.close()
when I execute the code it says the error is the value for name8 doesn't have a column. I don't know what to do
Aucun commentaire:
Enregistrer un commentaire