Click here to Skip to main content
15,886,362 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.6K   3.2K   50  
A tool to generate class files to implement stored procedures
// SPWListView.h : interface of the CSPWListView class
//
/////////////////////////////////////////////////////////////////////////////

#if !defined(AFX_SPWLISTVIEW_H__AE3C436D_083C_11D1_B2B9_444553540000__INCLUDED_)
#define AFX_SPWLISTVIEW_H__AE3C436D_083C_11D1_B2B9_444553540000__INCLUDED_

#include "SPWDoc.h"
#include "ListVwEx.h"

#if _MSC_VER >= 1000
#pragma once
#endif // _MSC_VER >= 1000

class CSPWListView : public CListViewEx
{
protected: // create from serialization only
	CSPWListView();
	DECLARE_DYNCREATE(CSPWListView)
	void UpdateSPWResultSetView();

// Attributes
public:
	CSPWDoc* GetDocument();

// Operations
public:
	BOOL Populate();
	int m_nSelectedItem;

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CSPWListView)
	protected:
	virtual void OnInitialUpdate(); // called first time after construct
	//}}AFX_VIRTUAL

// Implementation
public:
	virtual ~CSPWListView();
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif

protected:

// Generated message map functions
protected:
	BOOL PopulateMSSQLServerProcedures();
	BOOL PopulateSybaseSQLAnywhereProcedures(const CString& sSQL);
	//{{AFX_MSG(CSPWListView)
	afx_msg void OnKillFocus(CWnd* pNewWnd);
	afx_msg void OnSetFocus(CWnd* pOldWnd);
	afx_msg void OnItemChanged(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnDblclk(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnRclick(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnFileExecuteprocedure();
	afx_msg void OnFileGenerateCppClass();
	afx_msg void OnColumnClick(NMHDR* pNMHDR, LRESULT* pResult);
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
private:
	bool m_bSort;
};

#ifndef _DEBUG  // debug version in SPWListView.cpp
inline CSPWDoc* CSPWListView::GetDocument()
   { return (CSPWDoc*)m_pDocument; }
#endif

/////////////////////////////////////////////////////////////////////////////

//{{AFX_INSERT_LOCATION}}
// Microsoft Developer Studio will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_SPWLISTVIEW_H__AE3C436D_083C_11D1_B2B9_444553540000__INCLUDED_)

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