Python Forum
combining 2 tables af a special form
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
combining 2 tables af a special form
#1
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**)
Reply
#2
What type is billsf.yekdo, and what type is yord? Your error looks like they're not matching up.
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020