>Try stepping all the way through to verify it makes it to the ExecuteScalar() method of SQLCommand object. You have to have the Mere Mortals debug symbols added in order to step into that code or have the framework project added to your solution.
>Tim
Tim,
You are correct, the error is not on the ExecScalar command. I stepped through the framework code and the error is happening in the mmDataAccessBase class on this line:
public virtual object ExecScalar(IDbCommand command)
object Scalar;
command.CommandTimeout = this.CommandTimeout;
They are both of type int and I can see them in the watch window, but if I try to change the value of command.CommandTimeout it throws an execption.
It seems the most likely cause is I have a subclass of mmDataAccess for SqlCE (Compact Edition). I have to test with standard SQL, but I am not sure why this line in the base class is not allowing the change? Your support is very appreciated.
Kind Regards,
Mat