I have an access 2000 adp project with an SQL 2000 backend server, I am trying to call a stored procedure with an input and output parameter. My store procedures look like this:
Alter Procedure prcCHK
@cuid as int,
@pts as char(10) output
select top 1 @pts=pts from tblp1 where custid=@cuid
my access procedure look like
Dim CustomerID As Integer
Dim pts As String
CustomerID = 3065
Set dblocal = CurrentProject.Connection
dblocal.Execute ("prcCHK" & "'" & CustID & "' , '" & pts & "'")
All I want the code to do is call the stored procedure "prcCHK" and for it to return the a single value 'pts'
I have checked the syntax and it work fine outside of access (SQL Query Analyser) but does not when called from the access code. Any suggestions on how I can get the stored procedure to return a single value to the calling access procedure/function.