Python Forum
Database Submit Entry Syntax Error
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Submit Entry Syntax Error
#16
Okay so now I'm getting this error:

Error:
Traceback (most recent call last): File "C:\Users\jumbu\AppData\Local\Programs\Python\Python37-32\lib\tkinter\__init__.py", line 1705, in __call__ return self.func(*args) File "C:/Users/jumbu/Desktop/python/test.py", line 22, in submit c.execute("INSERT INTO Expense_Data.db VALUES (?, ?, ?, ?)", (l1.get(), l2.get(), l3.get(), l4.get())) AttributeError: 'Label' object has no attribute 'get'
Here's my full code although I'm not too sure if the problem is outside of that chunk I sent beforehand
from tkinter import *
import sqlite3

# Database Creation & Filename
conn = sqlite3.connect('Expense_Data.db')

# Create Cursor connecting to database
c = conn.cursor()

# Database Table Creation
'''
c.execute("""CREATE TABLE expenses   (
    name text,
    monthly_income integer,
    monthly_budget integer,
    monthly_cost_in_expenses integer
)""")
'''


def submit():
    c.execute("INSERT INTO Expense_Data.db VALUES (?, ?, ?, ?)", (l1.get(), l2.get(), l3.get(), l4.get()))
    c.execute("INSERT INTO Expense_Data.db VALUES (?, ?, ?, ?)")


# Finalise || Commit Changes
conn.commit()

# Create Window Object
window = Tk()

# Define table contents (each row/column)
l1 = Label(window, text="Name")
l1.grid(row=0, column=0)

l2 = Label(window, text="Monthly Income")
l2.grid(row=1, column=0)

l3 = Label(window, text="Monthly Budget")
l3.grid(row=2, column=0)

l4 = Label(window, text="Monthly Expenses")
l4.grid(row=3, column=0)

# Define Entries
name_text = StringVar()
e1 = Entry(window, textvariable=name_text)
e1.grid(row=0, column=1)

Monthly_Income_text = StringVar()
e2 = Entry(window, textvariable=Monthly_Income_text)
e2.grid(row=1, column=1)

Monthly_Budget = StringVar()
e3 = Entry(window, textvariable=Monthly_Budget)
e3.grid(row=2, column=1)

Monthly_Expenses = StringVar()
e4 = Entry(window, textvariable=Monthly_Expenses)
e4.grid(row=3, column=1)

# Define ListBox
list1 = Listbox(window, height=6, width=35)  # check this
list1.grid(row=5, column=0, columnspan=2)

# Attach scrollbar to the list
sb1 = Scrollbar(window)
sb1.grid(row=2, column=2, rowspan=6)

list1.configure(yscrollcommand=sb1.set)
sb1.configure(command=list1.yview)

# Define buttons
b1 = Button(window, text="View All", width=12)
b1.grid(row=2, column=3)

b2 = Button(window, text="Search Entry", width=12)
b2.grid(row=3, column=3)

b3 = Button(window, text="Add Entry", width=12)
b3.grid(row=4, column=3)

b4 = Button(window, text="Update Selected", width=12, command=submit)
b4.grid(row=5, column=3)

b5 = Button(window, text="Delete Selected", width=12)
b5.grid(row=6, column=3)

b6 = Button(window, text="Close", width=12)
b6.grid(row=7, column=3)
submit_btn = Button(text="Add Record to Database", command=submit)
submit_btn.grid(row=6, column=0, columnspan=2,)
window.mainloop() 
Reply


Messages In This Thread
Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 03:02 AM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 05:10 AM
RE: Database Submit Entry Syntax Error - by Denni - Jan-22-2020, 03:11 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 03:12 PM
RE: Database Submit Entry Syntax Error - by Denni - Jan-22-2020, 03:19 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 03:20 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 03:23 PM
RE: Database Submit Entry Syntax Error - by Denni - Jan-22-2020, 03:35 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 03:40 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 03:47 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 04:04 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 04:08 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 04:13 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 05:04 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 05:08 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 05:28 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 05:41 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 05:41 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 05:50 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 05:55 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 07:21 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 07:29 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 07:40 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-22-2020, 07:41 PM
RE: Database Submit Entry Syntax Error - by Melford - Jan-22-2020, 07:49 PM
RE: Database Submit Entry Syntax Error - by Denni - Jan-22-2020, 09:28 PM
RE: Database Submit Entry Syntax Error - by buran - Jan-23-2020, 04:15 AM
RE: Database Submit Entry Syntax Error - by Denni - Jan-27-2020, 04:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [Tkinter] Error verify data in database TomasSanchexx 2 945 Aug-11-2023, 12:37 PM
Last Post: TomasSanchexx
  [PyGUI] Invalid command error with Entry object eliqm 8 2,317 May-18-2023, 10:14 PM
Last Post: eliqm
  [Tkinter] Trying to add data into a shelf from a submit button TWB 8 1,922 Jan-06-2023, 11:30 PM
Last Post: TWB
  Usborne Coding for Beginners using Python 'Dodge the Bombs' Syntax Error CMSheWolfe 5 3,973 Jun-18-2020, 09:41 PM
Last Post: deanhystad
  Transfer Toplevel window entry to root window entry with TKinter HBH 0 4,513 Jan-23-2020, 09:00 PM
Last Post: HBH
  Problem with Submit button Tkinter Reldaing 2 3,722 Jan-05-2020, 01:58 AM
Last Post: balenaucigasa
  [Tkinter] how to get the entry information using Entry.get() ? SamyPyth 2 3,545 Mar-18-2019, 05:36 PM
Last Post: woooee

Forum Jump:

User Panel Messages

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