C / C++ / MFC

class CDBEvtRawInsert
{
public:
	// Data Elements
	int		f_Direction;
	int		f_HubID;
	TCHAR		f_RawEvent[1400];
	LARGE_INTEGER	f_RawEventID;

	BEGIN_COLUMN_MAP(CDBEvtRawInsert)
		COLUMN_ENTRY(1, f_RawEventID)
	END_COLUMN_MAP()

	// Parameter binding map
	BEGIN_PARAM_MAP(CDBEvtRawInsert)
		SET_PARAM_TYPE(DBPARAMIO_INPUT)
		COLUMN_ENTRY(1, f_Direction)
		COLUMN_ENTRY(2, f_HubID)
		COLUMN_ENTRY(3, f_RawEvent)
	END_PARAM_MAP()

	DEFINE_COMMAND_EX(CDBEvtRawInsert, L" \
							INSERT INTO [RawEvent] ([TimeStamp],[Direction],[Hub],[RawEvent])	\
							VALUES (GETDATE(),?,?,?);SELECT @@IDENTITY AS RawEventID")
};

CString szValue = _T("test");
HRESULT hr = E_FAIL;
CCommand<CAccessor<CDBEvtRawInsert >,CRowset, CMultipleResults > rsEvtRawInsert;

wcscpy_s(rsEvtRawInsert.f_RawEvent, szValue.GetLength()*2, szValue);
rsEvtRawInsert.f_Direction = 1;
rsEvtRawInsert.f_HubID = 0;
hr = rsEvtRawInsert.Open(theApp.m_oDB.session);         // <<==== fails here
if(S_OK == hr)
{
    DBROWCOUNT out;
    hr = rsEvtRawInsert.GetNextResult(&out);

class CMainFrame : public CMDIFrameWnd
{
	DECLARE_DYNAMIC(CMainFrame)
public:
	CMainFrame();

	CMainControlBar	m_MCB;			//the control bar
	CDataControls	m_GrabDataDialog; 	//the dialog attached to the control bar

//other stuff...
.
.
.
}

int CMainFrame::EnableControlBar()
{

	if (!m_MCB.Create(_T("Data Window"), this, 50))
	{
		TRACE0("Failed to create Data Window\n");
		return -1;
	}
	m_MCB.SetBarStyle(m_MCB.GetBarStyle() | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC );
	m_MCB.EnableDocking(CBRS_ALIGN_ANY);

#ifdef _SCB_REPLACE_MINIFRAME
    m_pFloatingFrameClass = RUNTIME_CLASS(CSCBMiniDockFrameWnd);
#endif 

	DockControlBar(&m_MCB, AFX_IDW_DOCKBAR_LEFT);
	
	//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	//~~~~  Attach Controls Dialog  
	//~~~~  to  Window if possible
	//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	if (!m_DataDialog.Create(IDD_MAINCONTROLS,&m_MCB))
	{
		TRACE0("Failed to create instant bar child\n");
		return -1;		// fail to create
	}

	//show the bar!
	m_DataDialog.ShowWindow(SW_SHOW);

	return 0;
}

class CDataControls : public CDialog
{
// Construction
public:
	virtual ~CDataControls();
	CDataControls(CWnd* pParent = NULL);   

	CGraphDraw m_Graph; //the custom control
	void DoDataDraw(); //passes data to the custom control
	void DoDataGrab(); //grabs data from an A/D converter

	BOOL m_TerminateThreads; 	//flag to terminate the thread
	CWinThread *pDataGrabThread; 	//thread pointer

	double	Sig[1024];

//other stuff...
.
.
.
};

BOOL CDataControls::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//Initialise Custom Control
	m_Graph.Initialise();

	//Setup Grab Thread
	pDataGrabThread = AfxBeginThread(DataGrabThread,this,THREAD_PRIORITY_NORMAL, 0, CREATE_SUSPENDED);		
        if(pDataGrabThread==NULL)
		AfxMessageBox(L"Crap Thread");

	pDataGrabThread->m_bAutoDelete=FALSE;
	pDataGrabThread->ResumeThread();
	
	
	return TRUE;
}

UINT DataGrabThread(LPVOID me)
{
	CDataControls *self = (CDataControls *)me;

	while(self->m_TerminateThreads!=0)
	{
		self->DoDataGrab(); 	//go and grab the data
		Sleep(100);		//don't hog the CPU
	}
	return 0;
}

void CDataControls::OnClose() 
{
	m_TerminateThreads=FALSE;  	//Signal terminate the thread

	WaitForSingleObject(pDataGrabThread->m_hThread,10000); //give it chance to stop
	delete pDataGrabThread; 	//then delete it
	
	CDialog::OnClose();
}

void CMainFrame::OnClose() 
{
	::SendMessage(m_ControlsDialog,WM_CLOSE,0,0);  //send a message to close the dialog and thread
	
	CMDIFrameWnd::OnClose();
}