🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Getting that Blob out of it's cave

#1531
From: Nigel
Date: Thu, 06 May 2004 17:40
31 lines
1923 bytes
Hi,

Maybe you can try using SaveToFile() or SaveToStream();
the easiest way is to make the BLOB field a persistant field in the ADOTable
(double click on the table and add the BLOB field).  Then you can issue a
command like ADOTable1BlobFieldName->SaveToFile("sound.wav");
Then you can open the file and play if from the drive and delete the file
afterwards or better still use the SaveToStream() and LoadFromStream()
functions of the components.

Maybe this approach is a little to simple but it might help.

"Kerby Arion" <kerby_am@hotmail.com> wrote in message
news:4098f2ce@newsgroups.borland.com...
> How can i get a BLOB from a Database (specially WAV SOUND).
>
> I use ADOConnection, ADOTable and a Datasource.
> Ms Jet 4.0 OLE DB Provider and a MS ACCESS Database File(.mdb)
>
> All is well except that i cannot use/get/see/play Sound from the Database;
>
> I try to use TOLEContainer but I cant connect it to my Datasource.
>
>
> Pls. Help me.
>
> How to get that BLOB, a sound file and the play it....
>
> Pls. Help me. i beg you.
>
>
Technical Details
Message-ID: <409a7889@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4098f2ce@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,8040945ed27e275e
X-Google-Attributes: gid10698b,public
From: "Nigel" <nhussey@absamail.co.za>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4098f2ce@newsgroups.borland.com>
Subject: Re: Getting that Blob out of it's cave
Date: Thu, 6 May 2004 19:40:30 +0200
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 196.39.91.43
Message-ID: <409a7889@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1083865225 196.39.91.43 (6 May 2004 10:40:25 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail