Click here to Skip to main content
15,879,535 members
Articles / Database Development / SQL Server

Interactive SQL Tool (using ADO)

Rate me:
Please Sign up or sign in to vote.
4.86/5 (16 votes)
17 Jan 2000 144.3K   10.1K   80  
A tool that allows you to query OLE DB sources
#if !defined(AFX_SELECTTABLES_H__8466BCB3_0FF4_11D2_AEF9_204C4F4F5020__INCLUDED_)
#define AFX_SELECTTABLES_H__8466BCB3_0FF4_11D2_AEF9_204C4F4F5020__INCLUDED_

#if _MSC_VER >= 1000
#pragma once
#endif // _MSC_VER >= 1000
// SelectTables.h : header file
//

/////////////////////////////////////////////////////////////////////////////
// CSelectTables dialog

class CChildFrame;

class CSelectTables : public CDialog
{
// Construction
public:
	CString m_strObjName;
	CString m_strType;
	CSelectTables(CWnd* pParent = NULL);   // standard constructor
	virtual ~CSelectTables();
	CString m_strSQL;

// Dialog Data
	//{{AFX_DATA(CSelectTables)
	enum { IDD = IDD_SELECT_TABLES };
	CButton	m_buttonTextOnly;
	CButton	m_buttonSystemTables;
	CButton	m_buttonViews;
	CListCtrlEx	m_ctrlList;
	BOOL	m_bTextOnly;
	CString	m_strSearch;
	//}}AFX_DATA
	
	CString m_strTableName;

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CSelectTables)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	// Generated message map functions
	//{{AFX_MSG(CSelectTables)
	virtual BOOL OnInitDialog();
	virtual void OnOK();
	afx_msg void OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnSystemTables();
	afx_msg void OnViews();
	afx_msg void OnChangeSearch();
	afx_msg void OnTextOnly();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()

private:
	bool GetColumnList(const CString& sTN, CString& sColumns);
	bool m_bSort;
	bool PopulateListEx();
	bool ApplyCriteriaAndPopulate();
	bool PopulateList();
	CChildFrame* m_pChildFrame;
};

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

#endif // !defined(AFX_SELECTTABLES_H__8466BCB3_0FF4_11D2_AEF9_204C4F4F5020__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