Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

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?  

0
mallow
Asked:
mallow
1 Solution
 
percosolatorCommented:
Yes, you can pass parameters to a SP.


0
 
BlackAndWhiteCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now