Feb-24-2022, 03:22 PM
In the following Update statement i get shown Exception. Below are the arguments.
Could it be the parentheses around argg that is causing issue?
If so, i have tried .strip() without success.
fldSet: 'loc=?,aquired=?,disposition=?'
criteria: 'tagNo=? and tagClr=? and tagYr=?'
argg: 'Hermas,Purchased,Died,22,Red,2014'
Could it be the parentheses around argg that is causing issue?
If so, i have tried .strip() without success.
fldSet: 'loc=?,aquired=?,disposition=?'
criteria: 'tagNo=? and tagClr=? and tagYr=?'
argg: 'Hermas,Purchased,Died,22,Red,2014'
def global_cowUpDte(self,fldSet,criteria,argg): self.c.execute (f'UPDATE cowTbl SET {fldSet} WHERE {criteria}',(argg)) Exception has occurred: ProgrammingError Incorrect number of bindings supplied. The current statement uses 6, and there are 35 supplied.Exception has occurred: