Stored Procedure Class Wizard 1.0

Stored Procedure Class Wizard (SPCW) is a useful development tool that allows you to generate class files (.cpp and .h) derived from MFC’s CRecordset for stored procedures. Currently SPCW supports Microsoft SQL Server (6.5 and above), Sybase SQL Server (10.0 and above), Sybase SQL Anywhere (5.5 and above), and Adaptive Server Anywhere (6.0 and above) and can be extended to any database.

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 from the 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
from the menu before generating the class files.

Step 3:
=======
Choose from the menu to generate .cpp and .h
recordset files.

Whenever you add/modify a procedure, choose from the
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 // MFC database classes

#define ODBC_DSN_INFO _T("ODBC;DSN= ")