mysql bindtype with array fails

Hi,

Dim ps as MySQLPreparedStatement = db.Prepare("INSERT INTO `table` (`fielda`, `fieldb`, `fieldc`, `fieldd`) VALUES (?, ?, ?, ?)") ps.BindType(array(ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING)) ps.SQLExecute("a", "b", "c", "d")

results in “4 parameters are being bound, but 3 types were specified”
it is always n - 1

with ps.BindType(array(ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING, ps.MYSQL_TYPE_STRING)) 'one more than needed

Is there something I can’t see or is it just a bug?

Marius

I was not aware BindType accepted an array. SQLExecute does say it accepts a ParamArray in the docs, BindType does not. Have you ever had it work in the past?

Curious to see what an engineer has to say.