Jan-22-2020, 05:10 AM
UPDATE:
I found the syntax error and renamed def b3 to the following:
I found the syntax error and renamed def b3 to the following:
def submit(): c.execute("INSERT INTO Expense_Data.db VALUES :l1, :l2, :l3, :l4")( { 'l1': l1.get(), 'l2': l2.get(), 'l3': l3.get(), 'l4': l4.get() })However now the error seems to be with the SQLite table here is the error:
Error:Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Users\jumbu\AppData\Local\Programs\Python\Python37-32\lib\tkinter\__init__.py", line 1705, in __call__
return self.func(*args)
File "C:/Users/jumbu/Desktop/python/test.py", line 22, in submit
c.execute("INSERT INTO Expense_Data.db VALUES :l1, :l2, :l3, :l4")(
sqlite3.OperationalError: near ":l1": syntax error