Click here to Skip to main content
15,898,134 members
Articles / Database Development / SQL Server

Stored Procedure Class Wizard (SPCW)

Rate me:
Please Sign up or sign in to vote.
4.76/5 (15 votes)
8 May 2001 185.9K   3.2K   50  
A tool to generate class files to implement stored procedures
Readme.Txt
==========
Stored Procedure Class Wizard (SPCW) is a development tool that can be
used exclusively to generate class files (.cpp and .h) derived from MFC's
CRecordset for stored procedures. 

Note that running SPCW against MS SQL Server or Sybase SQL Server
production databases is NOT recommended.

Following are the steps for generating class files:

Step 1:
=======
Choose <Connect> from the <File> menu.

Step 2:
=======
Select the procedure name for which you want to generate class files.

Microsoft SQL Server and Sybase SQL Server specific:

For procedures that return result set columns, choose <Execute Procedure>
from the <File> menu before generating the class files.

Step 3:
=======
Choose <Generate Class> from the <File> menu to generate .cpp and .h
recordset files.

Whenever you add/modify a procedure, choose <Refresh> from the <View>
menu and then repeat step 3 (steps 2 & 3 in the case of MS SQL Server
and Sybase SQL Server).

To connect to another data source, first disconnect the current connection
and then connect.

Add the following lines to StdAfx.h:

#include <afxdb.h> // MFC database classes

#define ODBC_DSN_INFO	_T("ODBC;DSN=<Data_Source_Name>")

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions