<div>
<div class="content wysiwyg-content">
I am having trouble using CDaoRecordset::AddNew. &nbsp; Basically I am trying to scan a table for a name. &nbsp;If that name is not there, I want to add it. &nbsp;Here is my code: 
 
 
strQuery.Format(&quot;select ArtistID from Artists where ArtistName = '%s'&quot;, pszArtistName); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
CDaoRecordset* pRS = new CDaoRecordset(m_pDB); 
CString cs(&quot;&quot;); 
 
try 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRS-&gt;Open(dbOpenDynaset, strQuery); 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int iRecords = pRS-&gt;GetRecordCount(); 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (!iRecords) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRS-&gt;AddNew(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRS-&gt;SetFieldValue(2, pszArtistName); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRS-&gt;Update(); 
&nbsp; &nbsp; &nbsp; &nbsp; } 
} 
catch (CDaoException* e) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AfxMessageBox(e-&gt;m_pErrorInfo-&gt;m_strDescription, MB_ICONEXCLAMATION); 
} 
 
---- 
 
The problem is that every time I try to call SetFieldValue I get an exception that says &quot;Item not found in this collection&quot;. &nbsp; The new row (blank however) is added to the table, I just can't set my data for that row. 
 
How can I accomplish this?
</div>
</div>

I am having trouble using CDaoRecordset::AddNew.   Basically I am trying to scan a table for a name.  If that name is not there, I want to add it.  Here is my code:


strQuery.Format("select ArtistID from Artists where ArtistName = '%s'", pszArtistName);
			
CDaoRecordset* pRS = new CDaoRecordset(m_pDB);
CString cs("");

try
{
	pRS->Open(dbOpenDynaset, strQuery);

	int iRecords = pRS->GetRecordCount();

	if (!iRecords)
	{
		pRS->AddNew();
		pRS->SetFieldValue(2, pszArtistName);
		pRS->Update();
        }
}
catch (CDaoException* e)
{
	AfxMessageBox(e->m_pErrorInfo->m_strDescription, MB_ICONEXCLAMATION);
}

----

The problem is that every time I try to call SetFieldValue I get an exception that says "Item not found in this collection".   The new row (blank however) is added to the table, I just can't set my data for that row.

How can I accomplish this?

Using AddNew with CDaoRecordset

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.