I want to first say I know that other people have had this problem, but I've looked through the responses to them and none of them has been similar enough to help me solve it.
I'm trying to trace an Entry box, and if the Entry is the right size go through a SQL database and find a corresponding value.
https://i.stack.imgur.com/egSX6.png is the GUI, the fields with the $ should update if criteria are filled.
I added this code to check the Entry:
def update_winner():
cursor = conn.cursor()
winner = winner_id.get()
school = school_name.get()
temp = school+winner
if len(temp) == 5:
cursor.execute("SELECT Rating FROM KIDS WHERE LocalID = ?", temp)
rating=cursor.fetchval()
cursor.execute("SELECT FirstName FROM KIDS WHERE LocalID = ?", temp)
name=cursor.fetchval()
winner_name.set(name)
winner_id.trace("w",update_winner)
ratings.mainloop()
When the StringVar
content is modified, the update_winner
function is called with 3 arguments (see What are the arguments to Tkinter variable trace method callbacks? for more details). Since your function does not take any argument, it gives you the error TypeError: update_winner() takes 0 positional arguments but 3 were given
.
To correct it, just change def update_winner():
in def update_winner(*args):
.