Plus 1 for # 4. I store links to numerous types of files - pdf, wav, mp3, doc, xls, etc. - in a table and then use shellexecute() to view / play the document. Works great.
Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com On 08/25/2011 08:10 AM, Dave Crozier wrote: > George, > You have 4 options. > > 1. Add the audio file into an OLE field in which case they will be played > automatically by whichever application is tied to the file extension by the PC > > 2. Convert the audio file into an ascii string and save it to a memo field > then piece it back together to a temporary file and play it using > ShellExecute() > > 3. Save to a Blob data type field > > 4. Hold the audio file in its original format in a preset folder and simply > store a link to it. > > Personally I would go the (4) route as you may soon break the 2Gb limit in > VFP with large files and apart from that the chances of data corruption are > small. If the database gets too large then you could always use SQLExpress to > hold the binary data which will go up to 10Gb and is free. > > The problem with memo fields is that the replaced data space never gets > reused unless the database is packed (pack memo) so if the file is constantly > updated then replaced records still take up space > > Dave > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > G Gambill > Sent: 25 August 2011 14:21 > To: [email protected] > Subject: In-bedded Audio Files > > I am looking for hints as to how (if possible) to inbed audio files within a > dbf (dbc) and play the via a VFP exe. > > Any suggestion? > > Thanks > > George > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
