SQlite UPDATE WHERE Syntax Error

Question

I have this code with 2 entry boxes in tkinter which are passed through a database. I am trying to create and update query which updates the record in the database however I do not know how to create this from entry boxes. I have already researched this error. Exercise and Weight are the two entry boxes with MemberID being used to identify which record to update. This is the code

        cursor.execute('''

        UPDATE Exercises
        SET (Exercise =?, Weight = ?)
        WHERE MemberID=? ;


    ''')

The error is sqlite3.OperationalError: near "(": syntax error

Please don't change your code after someone has posted an answer. This leads to confusion — DeepSpace
– DeepSpace, Commented Mar 9, 2018 at 20:59

Mureinik · Accepted Answer · 2018-03-09 20:49:50Z

2

The set clause shouldn't be surrounded with parenthesis, just remove them and you should be OK:

UPDATE Exercises
SET    Exercise = ?, Weight = ?
WHERE  MemberID = ?;

answered Mar 9, 2018 at 20:49

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

John McNulty Over a year ago

That creates an error sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 3, and there are 0 supplied.

DeepSpace Over a year ago

@JohnMcNulty Well, you are using ? so you should provide the arguments to execute. How should sqlite know what to replace ? with? Read how parameterized queries work

John McNulty Over a year ago

I have now edited the question to include more code.

Collectives™ on Stack Overflow

SQlite UPDATE WHERE Syntax Error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related