C / C++ / MFC

~_com_ptr_t() throw()<br />
   { <br />
       _Release(); <br />
   }

BeginWaitCursor();
		_RecordsetPtr rst;
		
		strWhere.Format("LinkID = %d",data);
		rst = theApp.GetRecordset(_T("*"),_T("tblLink") ,strWhere);
		CString str,strPath;
		FieldsPtr pFields = rst->GetFields();
		FieldPtr pField,pName;
		pField= pFields->GetItem(_T("FileBytes"));
		pName = pFields->GetItem(_T("Link"));
		unsigned long nLength = pField->GetActualSize();
		str.Format("%s",(char*)_bstr_t(pName->Value));
		_variant_t varBLOB = pField->GetChunk(nLength);
		pBuf = new BYTE[nLength];
		SafeArrayAccessData(varBLOB.parray,(void **)&pBuf);
		// Initialize the data member variable with the data.
		pBytes = pBuf;
		// Unlock the safe array data.
		SafeArrayUnaccessData(varBLOB.parray);
		::GetModuleFileName(NULL,szPath,512);
		strPath.Format("%s",szPath);
		int pos = strPath.ReverseFind('\\');

		strDirectory = strPath.Left(pos + 1) + "temp\\";
		strPath = strDirectory  + url;
		CreateDirectory(strDirectory,NULL);

		CFile file;
		CFileException ex;
		CFileStatus status;
		status.m_attribute = 0;
		if(file.Open(strPath,CFile::modeRead,&ex))
		{
			file.Close();
			CFile::SetStatus(strPath,status);
			DeleteFile(strPath);
		}
		
		if(file.Open(strPath,CFile::modeCreate | CFile::modeWrite,&ex))
		{
			file.Write(pBytes,nLength);
			file.Close();
			file.GetStatus(status);
			status.m_attribute |= 0x01; //read only
			CFile::SetStatus(strPath,status);
			int iReturn = (int) ShellExecute(NULL, _T("open"), strPath, NULL, NULL, SW_SHOWNORMAL);

			// If ShellExecute returns an error code, let the user know.
			if (iReturn <= 32)
				MessageBox (_T("Cannot open file.  File may have been moved or deleted."), _T("Error!"), MB_OK | MB_ICONEXCLAMATION) ;
			
			if(url.GetLength()==0)
				MessageBox (_T("This is an empty entry! Try clicking a filled link! "), _T("Error!"), MB_OK | MB_ICONEXCLAMATION) ;
		}//if(file.Open(strPath,CFile::modeCreate | CFile::modeWrite,&ex))
		else		//file might have been opened already
		{
			AfxMessageBox("File could not be opened from this location.\r\n"
				"Check to make sure you don\'t already have this attachment open.",MB_ICONINFORMATION);
		}
	}
	MYCATCHALL
	//delete [] pBuf;	url.ReleaseBuffer();
	EndWaitCursor();