4,018
社区成员




//先添加一个字段,为IMAGE类型,添加字段没有问题
strSQL = "";
strSQL.Format( "ALTER TABLE [%s] ADD [%s] IMAGE", strTableName, strName );
m_pConnection->Execute( _bstr_t( LPCTSTR(strSQL) ), &RecordsAffected, adCmdText );
//以二进制把数据写入到varBLOB
VARIANT varBLOB;
SAFEARRAY *psa;
SAFEARRAYBOUND rgsabound[1];
......
varBLOB.vt = VT_ARRAY | VT_UI1;
varBLOB.parray = psa;
//利用SQL语句修改字段的值,这里出错了,把VARIANT类型变量varBLOB换为其他类型运行没有问题
strSQL = "";
strSQL.Format( "UPDATE [%s] SET [%s] = varBLOB", strTableName, strName);
m_pConnection->Execute( _bstr_t( LPCTSTR( strSQL ) ), &RecordsAffected, adCmdText );