vendredi 19 février 2016

something is wrong inside my sqlite code but i can't see it

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