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 I run it, the instant I put anything into the Entry that feeds to winner_id I get the following error: TypeError: update_winner() takes 0 positional arguments but 3 were given.
Where are the arguments to update_winner() coming from? It's being called in the trace method and I don't think I'm passing anything.