Help Needed for Stored Procedure

[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

 

[Graham R Seach]

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