
SQL Stored Procedures Using Parameters in CR8.5/VB6
How do I incorporate a stored procedure that expects up to
four parameters into the RDC and how do I pass the
parameters at run time through VB? I am using a DSN less
ADO connection to a SQL Server 2000 database. I have
tried putting the "exec spVPOOverUnderRpt" where the SQL
query would go (the window that is displayed as if you
selected "Verify Database") and clicking OK yeilds an
error. I included nulls for each of the parameters and
crystal accepted the query e.g. "exec spVPOOverUnderRpt
null, null, null, null. How do I code the passing of the
parameters to SQL on the fly?
Tks,
Ted