🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2247

How to use TADOBlobStream?

#2247
From: Nautilus
Date: Thu, 11 Sep 2003 23:48
39 lines
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-mail

Show 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