🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: CreateBlobStream

#1728
From: Viatcheslav V. Vassiliev
Date: Tue, 20 Apr 2004 16:05
65 lines
3330 bytes
BlobField->LoadFromStream() and SaveToStream() works with any TStream
including TMemoryStream etc.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"kdl" <me@isp.net> �������/�������� � �������� ���������:
news:4085340d@newsgroups.borland.com...
> Don't I need to have a stream first?  I am trying to get data already
> contained in a blob field into a stream.  The program crashes when I try
to
> create a stream.
>
> thanks.
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:4084f3da$1@newsgroups.borland.com...
> > Why do not you use BlobField->LoadFromStream()?
> >
> > //------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> > ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "kdl" <me@isp.net> �������/�������� � �������� ���������:
> > news:4083e397@newsgroups.borland.com...
> > > I am having major difficulty in getting CreateBlobStream to work
> properly
> > > with Builder 6.  I am using the code below and I can get it to
compile,
> > but
> > > the program crashes with a message like "Invalid Variant Operation".
I
> am
> > > connected to a MS SQL database and the field that I am trying to
access
> is
> > > defined as a VarByte with a size of 8000.  The help in BCB6 is not
> correct
> > > for ADO blobs and I cannot find any other help on the web.  I am stuck
> at
> > > this point.  Please help if there are any sugestions.
> > >
> > >     int MemSize;
> > >     char *Buffer;
> > >     TADOBlobStream *Stream;
> > >
> > > //Crashes on this line.  I have tried many variations including
> > > "CreateBlobStream"with no success.
> > >     Stream = new TADOBlobStream((TBlobField
> > > *)adoTraceDetailsDataSet->FieldByName("TraceArray") , bmRead);
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <40854a43$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!border1.nntp.ash.giganews.com!border2.nntp.ash.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <4083e397@newsgroups.borland.com> <4084f3da$1@newsgroups.borland.com> <4085340d@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,eb986792cae970be
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-04-20 09:08:34 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4083e397@newsgroups.borland.com> <4084f3da$1@newsgroups.borland.com> <4085340d@newsgroups.borland.com>
Subject: Re: CreateBlobStream
Date: Tue, 20 Apr 2004 20:05:25 +0400
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <40854a43$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1082477123 213.234.218.42 (20 Apr 2004 09:05:23 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!border1.nntp.ash.giganews.com!border2.nntp.ash.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail