Qfyilyi

I'm building a simple inventory application in python and tkinter using sqlite3 as my database. The data entry works great, but for 2 weeks now I've been stuck on getting a search function working. I've tried numerous examples from this site and other places, but I continue to get errors or no output. Some of my functions have returned all results in the database, otherwise its an error or simply nothing. I can't figure out where I'm going wrong. Here is the current code (The search function has changed dozens of times, this is some of the latest code/version/attempt).

import tkinter as tk

from tkinter import Frame, TOP, LEFT, RIGHT, Label, Entry, StringVar, Text,

    END

import time

import tkinter.messagebox as messagebox

import sqlite3 as sqlite





conn = sqlite.connect('inventory.db')

c = conn.cursor





def create_table():

    try:

        conn.execute('''CREATE TABLE if not exists Inventory (

            HostName TEXT, User TEXT,

            Newhostname TEXT, Location TEXT)''')

        print('Table created successfully')

    except Error as e:

        pass



create_table()

conn.close()





Hostname=StringVar()

User=StringVar()

Newh=StringVar()

Location=StringVar()

Search=StringVar()



# ===== Display field ==========

textdisplay = Text(f2, height = 20, width=50, bd=15, font=('arial',

16, 'bold'))

textdisplay.grid(row=1, column=0, padx=(15,15))







#=============== SEARCH FUNCTION



def search_button():

    conn = sqlite.connect('inventory.db')

    c = conn.cursor()

    c.execute("SELECT * FROM Inventory")

    for row in c.fetchall():

        print(row)

        textdisplay.insert(END, "ttSearch Results: nn")

        textdisplay.insert(END, "Hostname: tt" + Hostname.get() + "nn")

        textdisplay.insert(END, "User: tt" + User.get() + "nn")

        textdisplay.insert(END, "New Hostname: tt" + Newh.get() + "nn")

        textdisplay.insert(END, "Location: tt" + Location.get() + "nn")



    conn.close()