
know anything about Stored Proc and using SQL Server 2000, CR8.5 and VB6.0
If anybody know anything about Stored Proc and using SQL Server 2000, CR8.5
and VB6.0
How to set Stored Proc name using RDC and the database is SQL server instead
of Access file.
The below example show to set the table name using access database to rdc.
Thanks
------------------------------------------------------
example
------------------------------------------------------
Public Sub AddDatabase()
'Variables used to setup the Database connection
Dim crDBTables As CRAXDRT.DatabaseTables
Dim sDatabasePath As String
Dim sTableName As String
'Get the Tables collection because it has the Add() method needed
'to add a connection to the report
Set crDBTables = crReport.Database.Tables
'Set the values for the connection variables
'The full path and name of the Access database.
'The database resides in the same directory as the application
sDatabasePath = App.Path & "\xtreme.mdb"
'The name of the Access table
sTableName = "Customer"
'Use the .Add() method to add the database table to the report.
'There are several optional arguments for the Add method. Which arguments
are passed
'will depend on the type of database, the type of table and the type of
connection.
'Add the 'Customer' table
crDBTables.Add sDatabasePath, sTableName
End Sub
-----------------------------------------------------------