results from query to textbox in GUI

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • v13tn1g
    New Member
    • Feb 2009
    • 31

    results from query to textbox in GUI

    so basically..what i have done is created a database, populated it and call that database from the GUI. When a user searches something in the database through the GUI, the result of the query displays next to the entry field. However, I need to display the results in a text field, for such instances where the results is really long. How do i do that?

    Code:
    from Tkinter import *
    import analyse
    
    
        
    def quit(window):
        window.destroy()    
    
    def query1(db, entry, text_box):
        text_box.insert(END, str(var.set(analyse.component_by_brand(db, entry.get()))))
        #var.set(analyse.component_by_brand(db, entry.get()))
        
    
    def query2(db, entry, var):
        var.set(analyse.price_with_serial(db, entry.get()))
        
    
    def query3(db, entry1, entry2, var):
        var.set(analyse.type_with_both(db, entry1.get(), entry2.get()))
        
    
    def run_analyse(db):
        window = Tk()
          
        frame = Frame(window)
        frame.pack()
        
        
        window.title(" Hardware Components")
        q1_prompt = Label(frame, text="Enter a Brand:")
        q1_prompt.grid(row=0, column=0)
        q1_data = Entry(frame)
        q1_data.grid(row=0, column=1)
        q1_command = lambda : query1(db, q1_data, q1_var)
        q1_button = Button(frame, text="Search for Type", command=q1_command)
        q1_button.grid(row=0, column=2)
        
        q1_var = StringVar()
        q1_result = Label(frame, textvariable=q1_var)
        q1_result.grid(row=0, column=3)               
        
        blank = Label(frame, text="")
        blank.grid(row=1, columnspan=4)
        
        q2_prompt = Label(frame, text="Enter the Serial Number:")
        q2_prompt.grid(row=2, column=0)
        q2_data = Entry(frame)
        q2_data.grid(row=2, column=1)
        q2_command = lambda : query2(db, q2_data, q2_var)
        q2_button = Button(frame, text="Search for price", command=q2_command)
        q2_button.grid(row=2, column=2)
        q2_var = StringVar()
        q2_result = Label(frame, textvariable=q2_var)
        q2_result.grid(row=2, column=3)                   
     
        blank2 = Label(frame, text="")
        blank2.grid(row=3, columnspan=4)
        
        q3_prompt = Label(frame, text="Enter the first part of the component:")
        q3_prompt.grid(row=4, column=0)
        q3_data = Entry(frame)
        q3_data.grid(row=4, column=1)   
        q3_prompt2 = Label(frame, text="Enter the second part of the component:")
        q3_prompt2.grid(row=5, column=0)
        q3_data2 = Entry(frame)
        q3_data2.grid(row=5, column=1)
        q3_command = lambda : query3(db, q3_data, q3_data2, q3_var)
        q3_button = Button(frame, text="Search for Name", command=q3_command)
        q3_button.grid(row=5, column=2)
        q3_var = StringVar()
        q3_result = Label(frame, textvariable=q3_var)
        q3_result.grid(row=5, column=3) 
        
        def text_box():
            w = Text(frame)
            w.grid(row=0,column=4, rowspan=13)
        
        quit_button = lambda : quit(window)
        b2 = Button(frame, text = "Quit", command = quit_button)
        b2.grid(row=6, column=1)
        
        window.mainloop()
  • v13tn1g
    New Member
    • Feb 2009
    • 31

    #2
    as you can see from my query1 function i tried the insert it into a text field but it wont work

    Comment

    Working...