🚀 go-pugleaf

Thanks very much for the help, but please excuse my ignorance.  I do not see
any references in help for load or save "toStream" relating to blobs or
"BobFields".  Would it be possible to show me an example of this method? If
I am connected to an MS SQL database that has a blob field defined as
varByte with  size of 8000, what would be the statement that I would use to
get this info from the field.  I am using an ADODataSet and the field is
named "TraceDetails' or fields[4].

thanks you very much for your assistance.

kev.


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40854a43$1@newsgroups.borland.com...
> 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);
> > > >
> > > >
> > >
> > >
> >
> >
>
>