saving a database on application exit

[davewelsh]

Hi. I need help

Does anyone know how to make a database save when the user exits the app? I don't want the user to have to move to another record to save.

 

[stupidog]

If you are using VC++ then serialize your data (in the Serialize function) and use SetModifiedFlag() to mark your document as dirty. This is done when you add or modify a variable in your program.

Steve

 

[davewelsh]

I'm not sure how to get it to work that way.

I started with an SDI Project from the MFC AppWizard and I chose my view class to de derived from CRecordView. The app will save automatically when the user moves through the record using the premade toolbar buttons or menu options, but it won't save the latest change if the user exits the program without moving throught the record first. I can make a button that saves when clicked by having it run the code:

void somefunction()
{
//check to see if the user created a new record
if (m_UpdateMode) //new record was created
{
UpdateData(TRUE);
if (m_pSet->CanUpdate())
m_pSet->Update();
m_pSet->Requery();
}

else //only edits of current records were made
{
if (m_pSet->CanUpdate())
{
m_pSet->Edit();
UpdateData(TRUE);
m_pSet->Update();
}
}

m_UpdateMode = FALSE;
UpdateData(FALSE);
}

Now if I could put this code in a place that always runs before the View Class is destroyed, I think I'd be set.

 

[davewelsh]

OK I guess that was dumb. The ON_WM_DESTROY message handler worked fine for calling the code before the app closed.

 

[Cagliostro]

If you are using MFC, just override CWinApp::ExitInstance and put there all code for destruct/saving/closing handles/files/databases/connections... John Fill

ivfmd@mail.md