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..
oCommand.CommandType = ADCMDSTOREDPROC
oCommand.CommandType = 4
oCommand.commandtext = "NumConv"
oCommand.parameters.refresh
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