BOOL CADORecordset::SetFieldEmpty(LPCTSTR lpFieldName) { _variant_t vtFld; vtFld.vt = VT_EMPTY; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, long lValue) { _variant_t vtFld; vtFld.vt = VT_I4; vtFld.lVal = lValue; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, COleDateTime time) { _variant_t vtFld; vtFld.vt = VT_DATE; vtFld.date = time; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, bool bValue) { _variant_t vtFld; vtFld.vt = VT_BOOL; vtFld.boolVal = bValue; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, double dblValue) { _variant_t vtFld; vtFld.vt = VT_R8; vtFld.dblVal = dblValue; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, unsigned long ulValue) { _variant_t vtFld; vtFld.vt = VT_UI4; vtFld.ulVal = ulValue; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, _variant_t vtValue) { _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtValue); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, int nValue) { _variant_t vtFld; vtFld.vt = VT_I2; vtFld.iVal = nValue; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, SYSTEMTIME time) { double vtime; _variant_t vtFld; SystemTimeToVariantTime(&time,&vtime); vtFld.vt = VT_DATE; vtFld.date = vtime; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldEmpty(int nIndex) { _variant_t vtFld; vtFld.vt = VT_EMPTY; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, SYSTEMTIME time) { double vtime; _variant_t vtFld; SystemTimeToVariantTime(&time,&vtime); vtFld.vt = VT_DATE; vtFld.date = vtime; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, COleCurrency cyValue) { if(cyValue.m_status == COleCurrency::invalid) return FALSE; _variant_t vtFld; vtFld.vt = VT_CY; vtFld.cyVal = cyValue.m_cur; return PutFieldValue(lpFieldName, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, bool bValue) { _variant_t vtFld; vtFld.vt = VT_BOOL; vtFld.boolVal = bValue; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, COleDateTime time) { _variant_t vtFld; vtFld.vt = VT_DATE; vtFld.date = time; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, double dblValue) { _variant_t vtFld; vtFld.vt = VT_R8; vtFld.dblVal = dblValue; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, unsigned long ulValue) { _variant_t vtFld; vtFld.vt = VT_UI4; vtFld.ulVal = ulValue; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(int nIndex, long lValue) { _variant_t vtFld; vtFld.vt = VT_I4; vtFld.lVal = lValue; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, wstring strValue) { _variant_t vtFld; if(!strValue.empty()) vtFld.vt = VT_BSTR; else vtFld.vt = VT_NULL; vtFld.bstrVal = _bstr_t( strValue.c_str()); BOOL bret = PutFieldValue(lpFieldName, vtFld); SysFreeString(vtFld.bstrVal); return bret; }
BOOL CADORecordset::SetFieldValue(int nIndex, COleCurrency cyValue) { if(cyValue.m_status == COleCurrency::invalid) return FALSE; _variant_t vtFld; vtFld.vt = VT_CY; vtFld.cyVal = cyValue.m_cur; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, CString strValue) { _variant_t vtFld; if(!strValue.IsEmpty()) vtFld.vt = VT_BSTR; else vtFld.vt = VT_NULL; //Corrected by Giles Forster 10/03/2001 vtFld.bstrVal = strValue.AllocSysString(); BOOL bret = PutFieldValue(lpFieldName, vtFld); //Corrected by Flemming27 at CodeProject.com SysFreeString(vtFld.bstrVal); return bret; }
BOOL CADORecordset::SetFieldValue(int nIndex, wstring strValue) { _variant_t vtFld; _variant_t vtIndex; vtIndex.vt = VT_I2; vtIndex.iVal = nIndex; if(!strValue.empty()) vtFld.vt = VT_BSTR; else vtFld.vt = VT_NULL; vtFld.bstrVal = _bstr_t( strValue.c_str()); return PutFieldValue(vtIndex, vtFld); }
BOOL CADORecordset::SetFieldValue(LPCTSTR lpFieldName, _variant_t vtValue) { return PutFieldValue(lpFieldName, vtValue); }