// Insert an item using INSERT SQL statement CString str; str.Format(TEXT("INSERT INTO Video (sTitle, sDesc, nHour, nMinute, fRating) VALUES ('%s', '%s', %d, %d, %g)"), record.m_strTitle, record.m_strDesc, record.m_nHour, record.m_nMinute, record.m_fRating); varSQL.bstrVal = SysAllocString(str); varSQL.vt = VT_BSTR;
hr = m_iADOCERS->Open(varSQL, m_varConn, adOpenDynamic, adLockOptimistic, adCmdUnknown); PrintHRESULT(hr); ASSERT(SUCCEEDED(hr));
SysFreeString(varSQL.bstrVal); |