I would also store the link. Not tried but there is also quite a good article on using MCI to play audio files at http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/209/Play-mp3-from-VFP
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 25 August 2011 16:16 To: GrahamB Subject: RE: In-bedded Audio Files 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.
