4,011
社区成员
发帖
与我相关
我的任务
分享
if((select count(*) from mydb.dbo.testTB where name='test')=0)
insert into mydb.dbo.testTB (name, memo) VALUES('test','测试数据')
select @@ROWCOUNT tempcnt
sqlquery ="if((select count(*) from mydb.dbo.testTB where name='test')=0) insert into mydb.dbo.testTB (name, memo) VALUES('test','测试数据') select @@ROWCOUNT tempcnt";
try
{
m_pRecordset = m_pConnection->Execute(sqlquery,&RecordsAffected,adCmdText);
while(!m_pRecordset->ADOEOF)
{
temprow=m_pRecordset->GetCollect("totalCnt");
temprow.ChangeType(VT_I4);
int uValue = temprow.lVal;
m_pRecordset->MoveNext();
}
//m_pRecordset->Close();
}
catch (_com_error e)
{
CString errormessage;
errormessage.Format(_T("插入失败!请重新点击按钮“输入数据库”!\r\n错误信息:%s 错误描述:%s"),e.ErrorMessage(),(LPCSTR)e.Description());
AfxMessageBox(errormessage);
return ;
}
while(!m_pRecordset->ADOEOF)
{
count=m_pRecordset->GetCollect("cnt");
m_pRecordset->MoveNext();
}
insertCnt=_ttoi((LPCTSTR)(_bstr_t)count);
enum VARENUM
{ VT_EMPTY = 0,
VT_NULL = 1,
VT_I2 = 2,
VT_I4 = 3,
VT_R4 = 4,
VT_R8 = 5,
VT_CY = 6,
VT_DATE = 7,
VT_BSTR = 8,
VT_DISPATCH = 9,
VT_ERROR = 10,
VT_BOOL = 11,
VT_VARIANT = 12,
VT_UNKNOWN = 13,
VT_DECIMAL = 14,
VT_I1 = 16,
VT_UI1 = 17,
VT_UI2 = 18,
VT_UI4 = 19,
VT_I8 = 20,
VT_UI8 = 21,
VT_INT = 22,
VT_UINT = 23,
VT_VOID = 24,
VT_HRESULT = 25,
VT_PTR = 26,
VT_SAFEARRAY = 27,
VT_CARRAY = 28,
VT_USERDEFINED = 29,
VT_LPSTR = 30,
VT_LPWSTR = 31,
VT_RECORD = 36,
VT_INT_PTR = 37,
VT_UINT_PTR = 38,
VT_FILETIME = 64,
VT_BLOB = 65,
VT_STREAM = 66,
VT_STORAGE = 67,
VT_STREAMED_OBJECT = 68,
VT_STORED_OBJECT = 69,
VT_BLOB_OBJECT = 70,
VT_CF = 71,
VT_CLSID = 72,
VT_VERSIONED_STREAM = 73,
VT_BSTR_BLOB = 0xfff,
VT_VECTOR = 0x1000,
VT_ARRAY = 0x2000,
VT_BYREF = 0x4000,
VT_RESERVED = 0x8000,
VT_ILLEGAL = 0xffff,
VT_ILLEGALMASKED = 0xfff,
VT_TYPEMASK = 0xfff
} ;