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
#1
Hello
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
Quote
#2
Please, show supporting code
Quote

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)