Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 how to use items combobox in table name sqlite in python
I'm developing a small application to manage my student class with python and sqlite3. I put the list of names of my classes in a combobox I retrieve the selected class in a variable but I cannot insert this variable in a sqlite3 request:
cursor.execute ("INSERT INTO mavariable ('Note', 'First name', 'Name', 'Number') VALUES (?,?,?,?)", (Number, First name, Name, Note))
thanks for the help
Please, show supporting code

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Mysql CREATE TABLE IF NOT EXISTS dynamic table name nisusavi 0 105 Apr-29-2020, 06:45 PM
Last Post: nisusavi
  Access list items in Python kamaleon 2 369 Dec-31-2019, 11:10 AM
Last Post: kamaleon
  MYSQL how to assign a table for each user in my username table database? YoshikageKira 1 409 Dec-26-2019, 05:57 AM
Last Post: buran
  SQLite Query in Python rowyourboat 2 626 Apr-26-2019, 02:24 PM
Last Post: Larz60+
  Updating records 1 to n on an SQLite table KevinBrown 2 407 Mar-30-2019, 05:02 PM
Last Post: KevinBrown
  how can a sqlite command like import be executed using sqlite3 (python) Larz60+ 1 501 Mar-08-2019, 01:17 AM
Last Post: Larz60+
  sqlite: INSERT using a variable for table name DT2000 3 1,279 Feb-23-2019, 06:28 AM
Last Post: DT2000
  finding problems connecting python to sqlite Dennis 1 517 Dec-10-2018, 02:58 PM
Last Post: Larz60+
  Python find the minimum length of string to differentiate dictionary items zydjohn 3 1,242 Mar-03-2018, 05:23 PM
Last Post: Gribouillis
  Running Date and Time in SQLITE using Python trabis03 3 1,878 Jul-17-2017, 02:10 AM
Last Post: Larz60+

Forum Jump:

Users browsing this thread: 1 Guest(s)