the complete error traceback is :
Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Users\AHMED\AppData\Local\Programs\Python\Python36\lib\tkinter\__init__.py", line 1702, in __call__
return self.func(*args)
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 55, in monitoring
update_releves()
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 47, in update_releves
for resultats in curseur.execute('SELECT * FROM releves where time_releves_axe_loc35R between first_day AND last_day ORDER BY time_releves_axe_loc35R DESC'):
sqlite3.OperationalError: no such column: first_day
at the end for information; there is the sample of the code to create table releves in the database 'test.db':
Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Users\AHMED\AppData\Local\Programs\Python\Python36\lib\tkinter\__init__.py", line 1702, in __call__
return self.func(*args)
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 55, in monitoring
update_releves()
File "C:\Users\AHMED\Desktop\mon_cev_exe\ddm_test.py", line 47, in update_releves
for resultats in curseur.execute('SELECT * FROM releves where time_releves_axe_loc35R between first_day AND last_day ORDER BY time_releves_axe_loc35R DESC'):
sqlite3.OperationalError: no such column: first_day
at the end for information; there is the sample of the code to create table releves in the database 'test.db':
def CreateTable_releves(): conn1_releves = sqlite3.connect('bdd/test.db') curseur1_releves = conn1_releves.cursor() curseur1_releves.execute('''CREATE TABLE IF NOT EXISTS releves (id INTEGER PRIMARY KEY,time_releves TEXT NOT NULL, monitor1_releves TEXT NOT NULL,monitor2_releves TEXT NOT NULL)''') curseur1_releves.close() def Add_To_Table_releves(): time_releves_get = str(date_choisie_ils35R) monitor1_releves_get = str(ent_releves_mesure1.get()) monitor2_releves_get = str(ent_releves_mesure2.get()) conn2_releves = sqlite3.connect('bdd/test.db') curseur2_releves = conn2_releves.cursor() curseur2_releves.execute('''INSERT INTO releves (time_releves,monitor1_releves,monitor2_releves) VALUES (?,?,?)''',(time_releves_get,monitor1_releves_get,monitor2_releves_get)) conn2_releves.commit() curseur2_releves.close()