def save():
global editor
conn = sqlite3.connect('address_book.db')
c = conn.cursor()
recordID = delete_box.get()
c.execute("""UPDATE addresses SET
first_name=:first,
last_name=:last,
address=:address,
city=:city,
state=:state,
zipcode=:zipcode
WHERE oid=:oid""",
{
'oid': int(recordID),
'first:': ef_name.get(),
'last': el_name.get(),
'address': eaddress.get(),
'city': ecity.get(),
'state': estate.get(),
'zipcode': ezipcode.get()})
conn.commit()
conn.close()
editor.destroy()
File "C:/Users/Luke/PycharmProjects/GUI/database.py", line 23, in save
c.execute("""UPDATE addresses SET
sqlite3.ProgrammingError: You did not supply a value for binding 1.
Can anybody see what is causing this error? I'm sure that I didn't make a typo anywhere and am very confused what could be the root of this.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…