Error: "sqlite3.Operationalerror: no such table"

Asked

Viewed 1,062 times

1

I’m making the following mistake:

sqlite3.Operationalerror: no such table: product

I already checked in my database, the product table is there

Code:

from tkinter import *
from tkinter import ttk
import sqlite3

root = Tk()
root.geometry('600x500+340+50')
root.title('Cadastro')
root.resizable(False,False)
root.configure(bg='azure')

banco = 'Database.db'

frame = LabelFrame(root, text='Adicionar Novo',bg='azure')
frame.grid(padx=200,pady=30)
lb = Label(frame,text='Nome:',width=15,bg='azure')
lb.grid(row=1,column=0)
lb2 = Label(frame, text='Preço:',bg='azure')
lb2.grid(row=2,column=0)

i = Button(frame,text='Adicionar',bg='azure')
i.grid(row=4,column=1,pady=4)
o = Label(frame)
o.grid(row=0,column=0)


name = Entry(frame)
name.grid(row=1,column=1,padx=5)

price = Entry(frame)
price.grid(row=2,column=1,padx=5)

tree = ttk.Treeview(height=12,column=2)
tree.grid(row=1,column=0,columnspan=2)
tree.heading('#0', text='Nome',anchor=CENTER)
tree.heading('#1', text='Preço',anchor=CENTER)

bt_ed = Button(text='Editar',bg='azure')
bt_ed.place(x=330,y=450)
bt_del = Button(text='Deletar',bg='azure')
bt_del.place(x=270,y=450)

parameters = ()
query = 'SELECT* FROM produto ORDER BY name DESC'
conn = sqlite3.connect(banco)
cur = conn.cursor()
query_result = cur.execute(query)
conn.commit()

records = tree.get_children()

for element in records:
    tree.delete(element)

db_rows = run_query(query)

for row in db_rows:
    tree.insert('',0,text=row[1],value=row[2])



root.mainloop()
  • In the variable banco, uses the absolute path, it may be that you are not finding the database file and creating a new one ;) EDIT: or simply put the file "Database.db" in the same directory as your project.

  • Check uppercase and minuscule depending on operating system makes difference.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.