C / C++ / MFC

void CompactAndRepairDB ()<br />
{<br />
	RETCODE retcode;<br />
	int     subscrp;<br />
<br />
	CHAR szDriver[]			= "Microsoft Access Driver (*.mdb)";<br />
	CHAR *szAttributes2[]	=<br />
								// Create the original .mdb file.<br />
								{"REPAIR_DB=db.mdb\0\0",<br />
<br />
								// Compact the file onto itself.<br />
								"COMPACT_DB=db.mdb db2.mdb General\0\0"};<br />
<br />
	for (subscrp = 0; subscrp <= ((sizeof szAttributes2 / sizeof(UCHAR *)) - 1); subscrp++)<br />
	{<br />
		retcode = SQLConfigDataSource (NULL, ODBC_ADD_DSN, szDriver, szAttributes2[subscrp]);<br />
		if (retcode != TRUE)<br />
		{<br />
			for(int i=1;i<=8;i++)<br />
			{<br />
				DWORD dwcode = NULL;<br />
				WORD wlen = 0;<br />
				char szerr[SQL_MAX_MESSAGE_LENGTH] = {0};<br />
				if (SQLInstallerError((WORD)i, &dwcode, szerr, SQL_MAX_MESSAGE_LENGTH-1, &wlen) == SQL_SUCCESS)<br />
					printf ("Code: %u %s\n",dwcode,szerr);<br />
			}<br />
		}<br />
	}<br />
}

<br />
std::string noRecords = "no records found"; // Dont ask me why, but this message always is wrong.<br />
for (int i = curr.numberOfElements(); i > 0; --i) <br />
   {<br />
      if (std::string::npos != curr.currentElement.info.find_first_of(noRecords))<br />
      {<br />
          return true;<br />
      }<br />
      curr.setToPreviousElement();<br />
   }<br />
return false;<br />
<br />