谢谢各位了 C++Build 4.0 总是说我 invaild blob length 在SQL SERVER 7.0
//字段说明为:pict_name char(10), m_pict image
//数据库为SQL SERVER 7.0 编程语言为c++build4.0
//问题是总是说我 invaild blob length
//谢谢各位了
//在DataBase中我以设为 blob szie = 90000
void __fastcall TForm1::FormCreate(TObject *Sender)
{
TB1->DatabaseName="bbb";
AnsiString S,S1;
for(int i=0;i<32767;i++) S1=S1+"a";
int aa=S1.Length();
for(int i=0;i<2;i++)
S=S+S1;
aa= S.Length();
TB1->Open();
TB1->Edit();
TB1->Insert();
TB1->FieldByName("pict_name")->AsString="1";
TB1->FieldByName("m_pict")->AsVariant=S.c_str();
TB1->Post();
if (TB1->State == dsEdit)
{
TBlobStream *pStream;
pStream =new TBlobStream((TBlobField*)TB1->FieldByName
("m_pict"),bmReadWrite);
pStream->Write(S.c_str,S.Length());
TB1->Post();
//问题是S不能超过32767长
delete pStream;
}
TB1->Close();
}