T
Terry
A Stored Procedure spPermissionsInsert inserts a record into a table and
returns a value @ReturnVal on completion. The code used returns an error that
the first parameter (and presumably the subsequent parameters) has not been
specified. Many examples are available for passing single parameters but not
multiple parameters.
1. Is it necessary to declare multiple parameters or can a single parameter
be used and redefined?
2. How do you get the return value?
3. Where can an example for multiple parameters be found?
Code used:
For i = 1 To 8
Set parm(i) = cmd.CreateParameter()
parm(i).Name = sParmName(i)
parm(i).Type = adTinyInt
cmd.Parameters.Append parm(i)
parm(i).Value = ParmVal(i)
Next
Thank you
Terry
returns a value @ReturnVal on completion. The code used returns an error that
the first parameter (and presumably the subsequent parameters) has not been
specified. Many examples are available for passing single parameters but not
multiple parameters.
1. Is it necessary to declare multiple parameters or can a single parameter
be used and redefined?
2. How do you get the return value?
3. Where can an example for multiple parameters be found?
Code used:
For i = 1 To 8
Set parm(i) = cmd.CreateParameter()
parm(i).Name = sParmName(i)
parm(i).Type = adTinyInt
cmd.Parameters.Append parm(i)
parm(i).Value = ParmVal(i)
Next
Thank you
Terry