Re: problem with insert/get image in MSSQL2K using ADO & C++ Builder 6

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

Article #829

Back to borland.public.cppbuilder.database.ado Previous Next

#829

From: Vladimir Stefanovic
Date: Sun, 29 May 2005 19:28

47 lines
2114 bytes

I have this saved in my archive, for similar approach connected
to TRichEdit. It's *untested*:

<quote>

   TMemoryStream* MemStream = new TMemoryStream();
   RichEdit1->SaveToStream( MemStream );
   MemStream->Seek( 0, soFromBeginning );

   TBlobStream* DBStream = (TBlobStream*) DataSet1->CreateBlobStream( 
DataSet1->FieldByName("field name"), bmReadWrite );
   DBStream->CopyFrom( MemStream, MemStream->Size );
   DataSet1->Post();

   delete MemStream;
   delete DBStream;

</quote>


-- 
Best regards,
Vladimir Stefanovic


"Daniel Stevanovic" <danste@neobee.net> wrote in message 
news:429a1002@newsgroups.borland.com...
> Does anyone knows why this doesn't work ? Please :(
>
>    table->Insert();    // table: TADOTable
>    ...
>    TMemoryStream *ms=new TMemoryStream();
>    Image1->Picture->Bitmap->SaveToStream(ms);    // Image1: TImage
> component
>    try
>    {
>      ((TBlobField*)table->Fields->Fields[4])->LoadFromStream(ms);
>    }
>    __finally
>    {
>      delete ms;
>    }
>
>    table->Post();
>
>
>

Technical Details

Message-ID: <429a17c2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!feed5.newsreader.com!newsreader.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <429a1002@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,cad40e3a9264a12d
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
References: <429a1002@newsgroups.borland.com>
Subject: Re: problem with insert/get image in MSSQL2K using ADO & C++ Builder 6
Date: Sun, 29 May 2005 21:28:13 +0200
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.117.212.65
Message-ID: <429a17c2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1117394882 82.117.212.65 (29 May 2005 12:28:02 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!feed5.newsreader.com!newsreader.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message