Mar-16-2017, 08:19 AM
i want to add **vazne** into another table(it maeans **vazne** will becomes one of the the second table columns )...when i print **vazne** , it returns correct value but as this format : [(360,)]...so when i add it into the second table,
i get the following error
[Exception in Tkinter callback
Traceback (most recent call last):
File "/usr/lib/python3.4/tkinter/__init__.py", line 1536, in __call__
return self.func(*args)
File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 609, in tozin2
self.whtable()
File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 645, in whtable
c.execute("INSERT INTO billsf (vaznf, id1, firs1,las1, yekdo, vaznemp) VALUES (?, ?, ?, ?, ?, ?)",(counter, f1, d1, e1, yord, vazne))
sqlite3.InterfaceError: Error binding parameter 5 - probably unsupported type.][/icode]
**billse** is the first table...**billsf** is the second table... **vazne** is selected based on 2 items in the first second...after calling **vazne** from the first table, it shoud be added to the second table(**billsf**)
i get the following error
[Exception in Tkinter callback
Traceback (most recent call last):
File "/usr/lib/python3.4/tkinter/__init__.py", line 1536, in __call__
return self.func(*args)
File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 609, in tozin2
self.whtable()
File "/home/pi/start/gui/jus-submeno-image-refreshh.py", line 645, in whtable
c.execute("INSERT INTO billsf (vaznf, id1, firs1,las1, yekdo, vaznemp) VALUES (?, ?, ?, ?, ?, ?)",(counter, f1, d1, e1, yord, vazne))
sqlite3.InterfaceError: Error binding parameter 5 - probably unsupported type.][/icode]
**billse** is the first table...**billsf** is the second table... **vazne** is selected based on 2 items in the first second...after calling **vazne** from the first table, it shoud be added to the second table(**billsf**)