>Hi John,
>
>I thought the problem with the automatic refresh of parameters is that it doesn't work on Oracle.
>
>You usually get the error "Provider cannot derive parameter information"
>On Both OLE-DB Providers. MSDAORA and OLEDBORA..
>
>

>**OK..
>oCommand.CommandType = ADCMDSTOREDPROC
>oCommand.CommandType = 4
>oCommand.commandtext = "NumConv"
>oCommand.parameters.refresh
>
>**Gives error
>oCommand.CommandType = 1
>oCommand.commandtext = "select * from styles where mainkey=?"
>oCommand.parameters.refresh
>
>

>
>When I tried to lookup the error I noticed strangely the parameters.refresh works for procedures and not select statements.

Nothing strange about that. The select statments don't have patameters they have arguments which are substituted by parameters.

>
>I think I might look into this further because it would solve all my problems.
>I didn't think it worked..
>
>Thanks