VC++ code to copy/move records from one database in to another database having the same table.

Download Library and header files from below link:
http://www.codeproject.com/KB/database/CppSQLite.aspx

int CopyMoveDBTable( LPCTSTR lpcSourceDBPath ,LPCTSTR lpcSourceTable , LPCTSTR lpcTargetDBPath ,LPCTSTR lpcTargetTable ,LPCTSTR lpcCriteria ,BOOL bCopy)
{

     CppSQLite3DB* m_db;     
     try
     {
          CString csQuery;               
          m_db=new CppSQLite3DB();          
          m_db->open(lpcSourceDBPath);           
          
          csQuery.Format( "Attach  '%s' as sourcedbTable;",lpcTargetDBPath); 
           m_db->execDML(csQuery); 
           m_db->execDML("begin transaction");
          csQuery.Format( "insert into sourcedbTable.%s select * from  main.%s  %s ;",lpcSourceTable,lpcTargetTable,lpcCriteria); 
          m_db->execDML("commit transaction");
          //insert into sourcedbTable.emptable select * from  main.embdb where empid < 1 ;"); 
           m_db->execDML(csQuery); 
          if(bCopy==FALSE)
          {
               m_db->execDML("begin transaction");
               csQuery.Format(  "delete from main.%s  %s ;",lpcSourceTable,lpcCriteria);
               m_db->execDML(csQuery); 
               m_db->execDML("commit transaction");
          }
          csQuery.Format( "DETACH sourcedbTable;"); 
          m_db->execDML(csQuery); 
          
          m_db->close();          
     }

     catch (CppSQLite3Exception& e)
     {
          delete m_db;
          
          AfxMessageBox( e.errorMessage());
          return -1;
     }
     delete m_db;
     
     return 1;

}     

EXample:

     CString csDBPath,csMirrorDB,csTable,csCriteria;
     BOOL bCopy=FALSE;
     csDBPath= "c:\\DatabaseSqlite\\Employee.db"; 
     csMirrorDB= "c:\\DatabaseSqlite\\Employeemirror.db"; 
     csTable="EmpTable";
     csCriteria="where empId>5";
     CopyMoveDBTable( csDBPath,csTable, csMirrorDB ,csTable ,csCriteria ,bCopy);

Code to close Current application

//Code to close Current application

AfxGetMainWnd()->PostMessage(WM_CLOSE);

Program to create shortcut programatically

int createshotcut(CString csShorcutFile,CString csSourceFile,CString csWorkingDirectory,CString Comments )
{
     CoInitialize( NULL );
     
     IShellLink* psl;
     
     // Get a pointer to the IShellLink interface.
     
     HRESULT hres = CoCreateInstance(CLSID_ShellLink, NULL, CLSCTX_INPROC_SERVER,
          
          IID_IShellLink, (PVOID *) &psl);
     
     if (SUCCEEDED(hres))
          
     {
          
          IPersistFile* ppf;
          
          // Set the path to the shortcut target and add the
          
          // description.
          
          psl->SetPath((LPCSTR) csSourceFile);
          
          psl->SetWorkingDirectory((LPCSTR)csWorkingDirectory);
          
          psl->SetDescription((LPCSTR) Comments );
          
          hres = psl->QueryInterface(IID_IPersistFile, (PVOID *) &ppf);
          
          if (SUCCEEDED(hres))
               
          {
               
               WORD wsz[MAX_PATH];
               
               MultiByteToWideChar(CP_ACP, 0, (LPCSTR) csShorcutFile, -1, wsz, MAX_PATH);
               
               hres = ppf->Save(wsz, TRUE);
               
               ppf->Release();
               
          }
          
          psl->Release();
          
     }
     
     CoUninitialize();

     return 1;
}


Example:
     createshotcut("c:\\mydairy.lnk","d:\\files\\secret.txt","d:\\","My Notepad Shortcut");