C / C++ / MFC

Larry Mills Sr wrote:

CString CMyDB::GetDefaultConnect()
{
return _T("DBQ=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb;DefaultDir=C:\\CookIt\\Program\\DataBases\\DB;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;");
}

return _T("ODBC;DSN=Gymnastics");

CDatabase *CMyDoc::GetDatabase( void )
{
    if (! m_rDatabase.IsOpen())
        m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=Gymnastics"));
  
    return (&m_rDatabase);
}

CMyRecordset set;
set.m_pDatabase = GetDocument()->GetDatabase();
  
TRY
{
    set.Open();
    set.AddNew();
    ...
    set.Update();
    set.Close();
}
CATCH(CDBException, pDBException)
{
    AfxMessageBox(pDBException->m_strError);
}
END_CATCH

Larry Mills Sr wrote:

the MS Access database is called "CookIt.mdb" and with the DSN iit is now "CookIt.mdb.dsn" Is this normal?

Larry Mills Sr wrote:

Now, you state you have a CDatabase in Documents. Do I declare it in the Header?

Larry Mills Sr wrote:

and how do I get the CRecordset m_pSet set to that database? I may be asking this wrong.

Larry Mills Sr wrote:

so if I used your code would mine be: m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt")); Is this right?

Larry Mills Sr wrote:

m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt.mdb.dsn"));

Larry Mills Sr wrote:

Do I have to make a recordset for each table?

msr_codeproject wrote:

What is the entry point for Message Mapping?

#include <vector>
using namespace std;

vector<string> vectorstr ;

....

vectorstr.push_back("....") 

...

for(int i=0;i<this->vectorstr.size(); i++){
			cout << "test:" << this->vectorstr.at(i) << endl;		
		}

...


void removeduplicates(vector<string>& vec){
  	sort(vec.begin(), vec.end());
    vec.erase(unique(vec.begin(), vec.end()), vec.end());    
  }

nuttynibbles wrote:

#include

#include <iostream>
#include <sstream>
#include <fstream>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <time.h>
#include <ctype.h>
#include <map>
#include <vector>
using namespace std;

#include <string>
#include <vector>
#include <iostream>
using namespace std;
void main()
{

  vector<string> vectorstr;
  vectorstr.push_back("...."); 

  for(int i=0;i<vectorstr.size(); i++)
  {
	  cout << "test:" << vectorstr.at(i) << endl;		
  }

}

// Cons.cpp : Defines the entry point for the console application.

#include "stdafx.h"
#include <iostream>
#include <vector>
#include <string>
#include <algorithm>

using namespace std;

void UniqueSort(std::vector<string>& MyVec)
{
	sort(MyVec.begin(), MyVec.end());
	MyVec.erase(unique(MyVec.begin(), MyVec.end()), MyVec.end());
}

int _tmain()
{
	vector<string> vec;
	vec.push_back("one"); 
	vec.push_back("two");
	vec.push_back("one");  //duplicate
	vec.push_back("four");
	vec.push_back("five");
	vec.push_back("six");
	vec.push_back("seven");
	vec.push_back("eight");
	vec.push_back("six"); //duplicate

	//cout<<"Before sorting"<<endl;

	int nSize = vec.size(); //9
	
	UniqueSort(vec);
	
	nSize = vec.size(); //7 (2 duplicates removed)

	//cout<<"After sorting"<<endl;

        return 0;
}