Passing multiple parameters to Stored Procedure

T

Terry

A Stored Procedure spPermissionsInsert inserts a record into a table and
returns a value @ReturnVal on completion. The Access ADO 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. Where can an example for multiple parameters be found?
2. Is it necessary to declare multiple parameters or can a single parameter
be used and redefined?
3. How do you get the return value?
4. The parameters in SQL Server are BITs. In Access ADO what is the
equivalent type?
Thank you
Terry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing multiple parameters to Stored Procedure 0
Report with data input from a stored procedure 0
Query with parameters set to a List Box displaying multiple values 1
Passing dates to Sql Server 2005 stored procedure 3
Return Values from SQL Server to MS Access 1
Access 2002 .adp subform linking using stored procedures 1
How do you pass parameters to a stored procedure 2
Accessing Stored Procedure via VBA 4

Top