>Cetin,
>
>It can be done even simpler with SQL Server OLE DB provider in VFP
>
>WITH This.oCommand
> .CommandType = ADCMDSTOREDPROC
> .CommandText = <Name of a stored procedure>
> .Parameters.Refresh
> * Now Parameters collection is populated with stored procedure parameters
> FOR Each loPrm In .Parameters
> ...
> ENDFOR
>ENDWITH
>
>
>>This wouldn't work if you use a generic driver like OleDb, no?
Sergey,
I know that but that is not what I meant. I wanted to say with some mechanism to query parameters (like ADO had it as in your sample for years or schema query/reflection) it wouldn't work with just relying on named parameters.
PS: Specifically talking about .Net OleDbCommand.
Cetin