On Mon, 11 Jun 2001 16:39:42 +0200, Bart Lateur wrote:
>DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access-driver]
>Not enough parameters. The expected count is: 6. (SQL-07001)(DBD:
>st_execute/SQLExecute err=-1)
>
>Huh? 6? I count only 5 question marks... What is going on?
I found a workaround, but I'm still not sure about what precisely is the
problem.
My perl code may remain unaltered. It turns out that one of the fields
of the table was marked as "required". Making it "not required" made it
work, even though this field was always present in the data.
I don't understand what is going on, but it smells like an
Access/Jet/ODBC (pick one) bug. (something to do with indexes?)
--
Bart.