Help Needed for Stored Procedure

  • Thread starter Thread starter Rahul
  • Start date Start date
R

Rahul

I have one stored procedure
It has Two Output Parameters
It returns Empty values
While debugging i have inserted Insert statement In Procedure
Table specified in insert Statement is not exists in DB
Though also Procedure doesn't gives error message but returns Empty
value

---------Thanks in advance for you kind support

Rahul
 
Rahul,

You need to set the value of both output parameters:
SET @Parameter1 = SELECT a FROM sometable
SET @Parameter2 = 'abc'

Then, of course, your VBA code needs to retrieve the values from the Command
object:
cmd.Execute
Debug.Print cmd.Parameters("@Parameter1")
Debug.Print cmd.Parameters("@Parameter2")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top