>>>>>>>>Can you post the line to call a method as the above was the one I posted.
>>>>>>>
>>>>>>>Whoever posted it, that is what worked
>>>>>>
>>>>>>Ok, just wanted to be sure. How many parameters does this method have?
>>>>>
>>>>>I'm not sure why you are interested as I have solved my problem, but there are 5 overrides for this method:
>>>>>
>>>>>ExecSprocScalar(string)
>>>>>ExecSprocScalar(string, out System.Data.IDbCommand, params System.Data.IDbDataParameter[])
>>>>>ExecSprocScalar(string, params System.Data.IDbDataParameter[])
>>>>>ExecSprocScalar(string, string, out System.Data.IDbCommand, params System.Data.IDbDataParameter[])
>>>>>ExecSprocScalar(string, string, params System.Data.IDbDataParameter[])
>>>>
>>>>I'm not sure I understand exactly, that's why I'm asking. We're using 2nd overload (I guess), but we're passing 4 parameters. How does it exactly work, e.g. why
>>>>
>>>>param1, param2 is the same as params IDbDataParameter[] ?
>>>>
>>>>E.g. how does C# understand it (as I know the same works for main program).
>>>
>>>Anyone can please clarify?
>>
>>ExecSprocScalar if used in a mmbusiness object is an mm method. The IdbDataParameter[] is a collection of parameters. You can add as many parameters as needed to support your stored procedure. You can use the mm method of this.CreateParameter("@paramName", value) as many times as needed sperated by commas to fill that collection.
>>
>>

>>return this.ExecSprocScalar("SPMyStoredProcedureName", 
>>     this.CreateParameter("@Param1", value1),
>>     this.CreateParameter("@Param2", value2));
>>

>>
>>I hope that was what you are asking.
>>Tim
>
>How exactly IdbDataParameter[] and Param1,Param2 correspond - this is the problem I'm not exactly getting. I know it works, but how C# knows to translate value1, value2 into array of values?
>
>In VFP that will not work, for example.


Because the method signature looks like this

protected virtual object ExecSprocScalar(string sprocName, out IDbCommand cmd, params IDbDataParameter[] dataParams)
{
	// Method code
}

Tim