[Python] Insert variables with Python and Tkinter into Sqlite3 table

Sorry this is my first post. I try to insert data into a sqlite3 table that I get using tkinter entries (Python).

But I always get empty columns in the table.

This is my code:

import sqlite3

from tkinter import *

def data_entry():

CDB.execute('insert into CUSTOMERS (NAME, CODE) VALUES (?, ?)', (NAME_E, CODE_E))

DB.commit()

CDB.close()
DB.close()

X=Tk()

NAME=StringVar()

CODE=StringVar()

DB=sqlite3.connect('DB.db')

CDB=DB.cursor()

CDB.execute('''create table if not exists CUSTOMERS
(ID integer primary key autoincrement,
NAME text(20), CODE text(10))''')

NAME_E=Entry(X,textvariable=NAME).pack()

CODE_E=Entry(X,textvariable=CODE).pack()

SAVE=Button(X,text='SAVE',command=data_entry).pack()

X.mainloop()

Continue reading...