'I want to update my SQLite3 database fields in Python tkinter and I'm getting errors
I'm trying to update the firstname field in my SQLite3 database, I tried using exception to get this error but couldn't still fix it.
This is the code:
conne = sqlite3.connect('C:/Users/JAY/PROGR/databases/STUDENT.sqlite3')
cursor = conne.cursor()
update_ = f'''UPDATE ADMISSION SET First_name = ? {new_1st_name_entry.get()} WHERE Mat_No == ? {mat_number_entry_.get()}'''
cursor.execute(update_)
messagebox.showinfo("UPDATED","Name Update Success.")
conne.commit()
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|