如题,代码如下
VARIANT varBLOB;
...
varBLOB.vt = VT_ARRAY | VT_UI1;
strSQL = "";
strSQL.Format( "UPDATE %s SET %s = varBLOB", UploadDlg.m_strFolderName, strName);
m_pConnection->Execute( _bstr_t( LPCTSTR( strSQL ) ), &RecordsAffected, adCmdText );
赋值有问题,运行老报错
正确的应该怎么写
VARIANT varBLOB;
...
varBLOB.vt = VT_ARRAY | VT_UI1;
strSQL = "";
strSQL.Format( "UPDATE %s SET %s = varBLOB", UploadDlg.m_strFolderName, strName);
m_pConnection->Execute( _bstr_t( LPCTSTR( strSQL ) ), &RecordsAffected, adCmdText );
赋值有问题,运行老报错
正确的应该怎么写
update tb set colname=你的VARIANT值
是不是和赋值的类型是VARIANT有关
给你个C#的参考下吧
string.Format( "UPDATE {0} SET {1} = varBLOB", UploadDlg.m_strFolderName, strName);