Output Parameters Return Nothing

  • Thread starter Thread starter Bob L.
  • Start date Start date
B

Bob L.

Hi everyone,

I am working with a SQL Server 2000 stored procedure, using an OleDbCommand
object to execute it. The stored procedure uses both input and output
parameters, and also returns rows. The whole thing works perfect, except
when I query the output parameters, they return a value of Nothing. If I run
the stored procedure in Query Analyzer, it works perfect.

Any ideas?

Thanks!
Bob L.
 
Bob:

If you would, please post the code, it'd be a little easier to narrow it
down.

Cheers,

Bill
 
Thanks for that request - it actually led me to a solution. As I was running
the code that I was preparing to post, I noticed that even though the Value
property of the parameter returned a value of Nothing when I evaluated it,
the correct return value was returned when I wrapped the value with CInt.
I'm not sure why just yet, but at least it works!

Thanks,
Bob
 
Back
Top