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.

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

Thanks