Python Forum
I need help creating tables with Sqlite3
Thread Rating:
  • 2 Vote(s) - 3.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I need help creating tables with Sqlite3
#4
(Sep-25-2017, 05:27 PM)buran Wrote: Note that your SQL statement is divided on two lines -12 and 13. You have ' at the end of line 12 and rest is orphan string on line 13

I did put a print in front of execute as nimalo suggested, and made line 12 and 13 in one line, and this did the job, which is interesting as that is how Pycharm is formating a line that is too long if i just copy/paste it into the interpreter.

Thanks you.
Reply


Messages In This Thread
I need help creating tables with Sqlite3 - by Rius2 - Sep-24-2017, 12:32 PM
RE: I need help creating tables with Sqlite3 - by Rius2 - Sep-28-2017, 05:49 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Creating a table in SQLite3 djwilson0495 2 2,071 Aug-10-2020, 03:01 PM
Last Post: djwilson0495
  Creating Tables in SQL danteslion 2 41,014 Jun-22-2019, 08:13 PM
Last Post: Gribouillis
  sqlite3 table structure and db tables pythonNoob 7 4,945 May-16-2018, 02:19 PM
Last Post: pythonNoob

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020