Aug-10-2023, 06:44 PM
hello.
I try to get autoincrement on column markID without success.
I dont want the keyword version of autoincrement.
What am I doing wrong in code?
TABLE:
I try to get autoincrement on column markID without success.
I dont want the keyword version of autoincrement.
What am I doing wrong in code?
TABLE:
cur.execute("""CREATE TABLE IF NOT EXISTS "MARKOR"( 'markID' INT PRIMARY KEY, longitude FLOAT NOT NULL, latitude FLOAT NOT NULL, xcoord INT NOT NULL, ycoord INT NOT NULL, dato DATE NOT NULL, objførstenavn TEXT NOT NULL, mellomnavn TEXT, objsistenavn TEXT, stednavn TEXT NOT NULL, "KART_kartID" INT, "BILDEKART_bkartID" INT, CONSTRAINT "KART_MARKOR" FOREIGN KEY ("KART_kartID") REFERENCES "KART" ("kartID"), CONSTRAINT "BILDEKART_MARKOR" FOREIGN KEY ("BILDEKART_bkartID") REFERENCES "BILDEKART" ("bkartID") )""")DATA/TYPES INSERT AND COMMIT:
item = ('NULL','11.446','50','1200',today,'Per','Roger','Hansen','Østmarksetra','5','7') cur.execute("""INSERT OR IGNORE INTO MARKOR VALUES(?,?,?,?,?,?,?,?,?,?,?,?)""",item) con.commit() OUTPUT FROM TERMINAL: [error] Output from Python terminal: return self.func(*args) ^^^^^^^^^^^^^^^^ File "D:\Python311\Lib\site-packages\customtkinter\windows\widgets\ctk_button.py", line 554, in _clicked self._command() File "d:\Python311\Scripts\nye.py", line 435, in dbtol cur.execute("""INSERT OR IGNORE INTO MARKOR VALUES(?,?,?,?,?,?,?,?,?,?,?,?)""",item) sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 12, and there are 11 supplied. PS C:\Users\jan-e> & D:/Python311/python.exe d:/Python311/Scripts/nye.py Exception in Tkinter callback Traceback (most recent call last): File "D:\Python311\Lib\tkinter\__init__.py", line 1948, in __call__ return self.func(*args) ^^^^^^^^^^^^^^^^ File "D:\Python311\Lib\site-packages\customtkinter\windows\widgets\ctk_button.py", line 554, in _clicked self._command() File "d:\Python311\Scripts\nye.py", line 435, in dbtol cur.execute("""INSERT OR IGNORE INTO MARKOR VALUES(?,?,?,?,?,?,?,?,?,?,?,?)""",item) sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 12, and there are 11 supplied. SEEN IN DB-browser: [output] NULL 60.25 11.446 50 1200 10-08-2023-20-38-12 Per Roger Hansen Østmarksetra 5 7 [/output] [/error]