I can't find anything wrong with the query, but yet is not working. Any help is appreciated!
Exception in Tkinter callback Traceback (most recent call last): File "E:\Python\lib\tkinter\__init__.py", line 1885, in __call__ return self.func(*args) File "c:\Users\User\Desktop\Employment Application\myemployees.py", line 412, in updateEmployee cur.execute(query,(name, surname, address, phone, email, age, position, salary, employment, education, criminalr, vacation, citizenship, notes, date_start, date_end, ssn, duties)) sqlite3.OperationalError: near "=": syntax error PS C:\Users\User\Desktop\Employment Application>
if (name, surname, address, phone, email, age != ''): try: query = "UPDATE 'employees' SET (employee_name=?, employee_lastname=?, employee_address=?, employee_phone=?,employee_email=?, employee_age=?) WHERE employee_id = ?" cur.execute(query,(name, surname, address, phone, email, age)) con.commit() messagebox.showinfo('Success!', 'The new employee is successfully added!', icon = 'info') except EOFError as e: print(e) messagebox.showerror('Error', 'Fatal Error Occurred!', icon = 'error') else: messagebox.showwarning('Warning', 'Feilds can NOT be empty!', icon = 'warning') 