SQL Stored Procedures Using Parameters in CR8.5/VB6 
Author Message
 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



Sun, 02 Jan 2005 04:24:04 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. know anything about Stored Proc and using SQL Server 2000, CR8.5 and VB6.0

2. VB6->SQL 7 Stored Procedure with Parameters

3. Need HELP about CR8 and stored procedure parameters

4. Re : CR8 and stored procedure parameters

5. CR8 and stored procedure parameters

6. How to passing parameters from and to a SQL Server stored procedure using ADO

7. CR8 & VB , Stored Procedures SQL 7.0

8. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

9. VB6 and stored procedures using SQL 6.0

10. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

11. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

12. ado recordsets from stored procedures, stored procedures have input parameters

 

 
Powered by phpBB® Forum Software