Greetings,
I've been playing around with sqlite in python. I have this issue where I need the primary key to increment (sql side only). It keeps inserting null values there even if I specify to not allow null. :D
Anyone have success with this? I've googled and found a few suggestions; no luck. It always has the same results. I also get the same results if I slam the insert function in my script or if I take it nice and slow. I must be doing something wrong.
connection method:
connect = sqlite3.connect(sqlFile, isolation_level=None)
![[Image: SL0xQm4.png]](https://i.imgur.com/SL0xQm4.png)
I've been playing around with sqlite in python. I have this issue where I need the primary key to increment (sql side only). It keeps inserting null values there even if I specify to not allow null. :D
Anyone have success with this? I've googled and found a few suggestions; no luck. It always has the same results. I also get the same results if I slam the insert function in my script or if I take it nice and slow. I must be doing something wrong.
connection method:
connect = sqlite3.connect(sqlFile, isolation_level=None)
