Search code examples
pythontkintersqlitesql-delete

Sqlite3 Deleting a searched record from a tkinter box

I am currently coding a program which has an account system. When deleting an account a user searches for the records details, which if successful, appears in a box on the screen. My problem is that I cannot find a solution to deleting the searched record. This is my current code:

def delete_member(self):    
            conn = sqlite3.connect(r"F:\Program\Accounts.db")

            cursor = conn.cursor()

            Name = self.ent_Name.get()
            MemberID = self.ent_MemberID.get()

            List = [Name, MemberID]

            cursor.execute("DELETE FROM members(Name, MemberID) VALUES (?,?)",(Name, MemberID))
            conn.commit()

Thanks for any help.

Solution

  • You're using the wrong syntax for delete.

    https://www.sqlite.org/lang_delete.html

    cursor.execute("DELETE FROM members WHERE Name=? AND MemberID=?",(Name, MemberID))