Parameter Values from Stored Procedure


hi there, i am using crystal report 5.0, and i have a stored procedure from informix,
that asks for two parameters, when i run my report can i get the value of the paramaters
that i asked from the stored procedure? how can i do this?  

mallowAsked:
Who is Participating?
 
BlackAndWhiteConnect With a Mentor Commented:
No you cannot access the stored procedure parameters directly.  You have to include the stored procedure parameters in the select statement.

Say your select statement in stored procedure is
"Select * from tblProducts" then

change it to
"Select *, @ProductCode, @ProductId from tblProducts"

where @ProductCode, @ProductId are the parameters.

I am definite that you cannot access stored procedure parameters directly.  I even talked to the Crystal tech support on this.

Note: To set the values of stored procedure parameters from vb, using crystal activex, use .StoredProcParam property.


0
 
percosolatorCommented:
Yes, you can pass parameters to a SP.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.