Python Forum
how to use items combobox in table name sqlite in python
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
Reply
#2
Please, show supporting code
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  concatenating 2 items at a time in a python list K11 3 236 Oct-21-2020, 09:34 AM
Last Post: buran
  Unable to Update SQLite Table sambanerjee 5 381 Sep-30-2020, 12:21 PM
Last Post: Larz60+
  Fetch Oracle DB rows & print it in HTML file with table's col headers in table format tssr_2001 1 489 Sep-04-2020, 01:39 PM
Last Post: ibreeden
  How to create db table with SQLite and SQLAlchemy?? marcello86 1 488 Sep-02-2020, 03:05 PM
Last Post: marcello86
  Importing data from a text file into an SQLite database with Python macieju1974 7 653 Jun-29-2020, 08:51 PM
Last Post: buran
  Mysql CREATE TABLE IF NOT EXISTS dynamic table name nisusavi 0 393 Apr-29-2020, 06:45 PM
Last Post: nisusavi
  Access list items in Python kamaleon 2 694 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 842 Dec-26-2019, 05:57 AM
Last Post: buran
  SQLite Query in Python rowyourboat 2 926 Apr-26-2019, 02:24 PM
Last Post: Larz60+
  Updating records 1 to n on an SQLite table KevinBrown 2 677 Mar-30-2019, 05:02 PM
Last Post: KevinBrown

Forum Jump:

User Panel Messages

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