Jan-02-2022, 03:06 PM
I have compared this code with similar queries that work. Can anyone see what I am missing that is causing the Syntax Error?
Error:Exception has occurred: OperationalError (note: full exception trace is shown but execution is paused at: <module>)
near "tagNo": syntax error
File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 92, in insert_Cow
self.c.execute(""" INSERT INTO cowTbl
File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 665, in cow_saveAdd
self.db.insert_Cow(
File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 1316, in <module> (Current frame)
CreateApp().run()def insert_Cow(self,tagNo,tagClr,tagYr,type,des,
loc,locDte,birthDte,birthWt,weanDte,weanWt,sex,status,aquired,
aquiredDte,aquiredCst,disposition,dispDte,soldAmt,bredDte,
bullTagNo,bullTagClr,bullTagYr,actCalvDte,calfTagNo,calfTagClr,calfTagYr):
self.c.execute(""" INSERT INTO cowTbl
VALUES
tagNo=?,
tagClr=?,
tagYr=?,
type=?,
desc=?,
loc=?,
locDte=?,
birthDte=?,
birthWt=?,
weanDte=?,
weanWt=?,
sex=?,
status=?,
aquired=?,
aquiredDte=?,
aquiredCst=?,
disposition=?,
dispositionDte=?,
soldAmt=?,
bredDte=?,
bredByTag=?,
bredByTagClr=?,
bredByTagYr=?,
actCalvDte=?,
calfTagNo=?,
calfTagClr=?,
calfTagYr=?
""",
(tagNo,tagClr,tagYr,type,des,loc,locDte,birthDte,birthWt,weanDte,weanWt,sex,status,aquired,
aquiredDte,aquiredCst,disposition,dispDte,soldAmt,bredDte,
bullTagNo,bullTagClr,bullTagYr,actCalvDte,calfTagNo,calfTagClr,calfTagYr))
self.con.commit()
