On a related note, if how can I access the error code I am sending back from Stored Proc using Return statement, to show up in a text box on report?
.. uspSomeStoredProc...
If error occured
Return -1
elseif some other error
Return 1
else
Return 0
End
Is there a way to display that? In general, how can the values that are returned by stored procs such as RowsAffected or some err code using RETURN or Output Variable be accessed in report? I don't see any properties exposed by datasets in the expression window for doing that.
Any input on this will be appreciated.
Thanks.
|||Any one? Any suggestions or input on this?
No comments:
Post a Comment