Article View: borland.public.cppbuilder.database.ado
Article #2247How to use TADOBlobStream?
From: Nautilus
Date: Thu, 11 Sep 2003 23:48
Date: Thu, 11 Sep 2003 23:48
39 lines
2122 bytes
2122 bytes
I want to update a blob field in my table of MS Sql Server database. I use
code below, but it isn't work and report a exception:String or binary data
would be truncated. What can I do?
void __fastcall Tfrm::buttonUploadClick(TObject *Sender)
{
ADOConnection1->Connected=true;
ADOTable1->Active=true;
ProgressBar1->Max=ADOTable1->RecordCount;
ProgressBar1->Position=0;
ADOTable1->First();
while(!ADOTable1->Eof){
Application->HandleMessage();
if(Trim(ADOTable1->FieldByName("download_URL")->AsString)!="")
{
String strSql = "update papers set pdf=:pdf where id=" ;
strSql+=ADOTable1->FieldByName("id")->AsString ;
ADOQuery1->Close();
ADOQuery1->Parameters->Clear();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(strSql);
ADOQuery1->Parameters->ParamByName("pdf")->LoadFromFile(editFolder->Text+"\\
"+ADOTable1->FieldByName("download_URL")->AsString, ftBlob);
ADOQuery1->ExecSQL();
}
ProgressBar1->Position+=1;
ADOTable1->Next();
}
ShowMessage("���");
}
Technical Details
Message-ID:
<3f64fe12$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,a8b6f75aa6d55f47,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-09-14 16:55:34 PST From: "Nautilus" <xiebg@panda.ioz.ac.cn> Newsgroups: borland.public.cppbuilder.database.ado Subject: How to use TADOBlobStream? Date: Fri, 12 Sep 2003 07:48:01 +0800 Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 NNTP-Posting-Host: 159.226.67.181 Message-ID: <3f64fe12$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1063583250 159.226.67.181 (14 Sep 2003 16:47:30 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail