Python Forum
Database Submit Entry Syntax Error
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Submit Entry Syntax Error
#6
c.execute("INSERT INTO Expense_Data.db VALUES (?, ?, ?, ?)", (l1.get(), l2.get(), l3.get(), l4.get()))
of course you can define the tuple (l1.get(), l2.get(), l3.get(), l4.get()) and assign it to name before that, on separate line, and use that name instead

payload = (l1.get(), l2.get(), l3.get(), l4.get())
c.execute("INSERT INTO Expense_Data.db VALUES (?, ?, ?, ?)", payload)
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

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 1,018 Aug-11-2023, 12:37 PM
Last Post: TomasSanchexx
  [PyGUI] Invalid command error with Entry object eliqm 8 2,470 May-18-2023, 10:14 PM
Last Post: eliqm
  [Tkinter] Trying to add data into a shelf from a submit button TWB 8 2,007 Jan-06-2023, 11:30 PM
Last Post: TWB
  Usborne Coding for Beginners using Python 'Dodge the Bombs' Syntax Error CMSheWolfe 5 4,046 Jun-18-2020, 09:41 PM
Last Post: deanhystad
  Transfer Toplevel window entry to root window entry with TKinter HBH 0 4,554 Jan-23-2020, 09:00 PM
Last Post: HBH
  Problem with Submit button Tkinter Reldaing 2 3,770 Jan-05-2020, 01:58 AM
Last Post: balenaucigasa
  [Tkinter] how to get the entry information using Entry.get() ? SamyPyth 2 3,574 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