catch(_com_error &e)
{
// Notify the user of errors if any.
// Pass a connection pointer accessed from the Recordset.
PrintProviderError(pConnection);
PrintComError(e);
}
}
//////////////////////////////////////////////////////////
// //
// PrintProviderError Function //
// //
//////////////////////////////////////////////////////////
void PrintProviderError(_ConnectionPtr pConnection)
{
// Print Provider Errors from Connection object.
// pErr is a record object in the Connection's Error collection.
ErrorPtr pErr = NULL;
if( (pConnection->Errors->Count) > 0)
{
long nCount = pConnection->Errors->Count;
// Collection ranges from 0 to nCount -1.
for(long i = 0; i < nCount; i++)
{
pErr = pConnection->Errors->GetItem(i);
printf("\t Error number: %x\t%s", pErr->Number,
(LPCSTR)pErr->Description);
}
}
}
//////////////////////////////////////////////////////////
// //
// PrintComError Function //
// //
//////////////////////////////////////////////////////////
//This Class extracts only titleId from Titles table.
class CTitlesRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CTitlesRs)
// Column title_id is the 1st field in the recordset
// from Titles table.
ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_szt_titleid,
sizeof(m_szt_titleid), lt_titleidStatus, FALSE)
// Open title Table
TESTHR(pRstTitles.CreateInstance(__uuidof(Recordset)));
pRstTitles->Open("SELECT title_id FROM titles",
_variant_t((IDispatch *)pConnection),
adOpenStatic, adLockReadOnly, adCmdText);
// The default parameters are sufficient to search forward
// through a Recordset.
pRstTitles->Find ("title_id LIKE 'BU%'",0,adSearchForward,"");
//Open an IADORecordBinding interface pointer which
//we'll use for Binding Recordset to a class
TESTHR(pRstTitles->QueryInterface(
__uuidof(IADORecordBinding),(LPVOID*)&picRs));
//Bind the Recordset to a C++ Class here
TESTHR(picRs->BindToRecordset(&titlers));
// Skip the current record to avoid finding the same
// row repeatedly. The bookmark is redundant because Find
// searches from the current position.
int count = 0;
//Continue if last find succeeded.
while (!(pRstTitles->EndOfFile))
{
printf("Title ID: %s\n",titlers.lt_titleidStatus == adFldOK ?
titlers.m_szt_titleid : "<NULL>");
count++; //Count the last title found.
_variant_t mark = pRstTitles->Bookmark; //Note current pos.
pRstTitles->Find("title_id LIKE 'BU%'", 1, adSearchForward,
mark);
}
//Release IADORecordset Interface
if (picRs)
picRs->Release();
// Clean up objects before exit.
pRstTitles->Close();
pConnection->Close();
printf("The number of business titles is %d\n",count);