SadMan
asked on
SQL Stored Procedure return values
How do i get the return value from a stored procedure, I know the sql is:
exec @ret = sp_check
but i would like to get the return value so that access can respond to it.
exec @ret = sp_check
but i would like to get the return value so that access can respond to it.
what we do is return the code via a select and store the results in a resultset. I don't beleieve DAO can handle return values from stored procedures. ADO can but that would mean adding an ado reference to you Access code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thats output parameters not return values. very different.
Sorry, I misread the question...
ASKER
Ethier way is OK, I can eaily re-write the stored proc, I think...
I'm going to try your answer dtomyn.
I'm going to try your answer dtomyn.
ASKER
Thanks dtomyn, not exactly what I was after but changing the code allowed me to get the results.
It worked perfectly.
It worked perfectly.