Pypyodbc Execute Returns List Index Out Of Range Error

I have a function that runs 3 queries and returns the result of the last (using the previous ones to create the last) when I get to the 3rd query, it get a list index our of range

Solution 1:

I've had the same error. Even though I haven't come to the definite conclusion about what this error means I thought my guessing might help anyone else ending up here.

In my case, the problem was a conflict with a datatype length (NVARCHAR(24) and CHAR(10)).

So I guess this IndexError in ctrl_err function just means there is an error in your SQL code that pypyodbc does not know how to handle.

I know this is not much of an answer, but I know it would have saved me a couple of hours had I known this was not some bug in pypyodbc but an inconsistency in the data I was inserting.

Kind regards, Luka