You could use a binary memo field (still limited to 2 GB total) but a memo field will not allocate new space if the table is used exclusive when the replace takes place (same size or smaller). Be warned it would still allocate new space even if exclusive when the new data is larger than the existing space.
Just another option, but a character field with a path to the file is usually better, just requires you to keep track of the files separately. Fred On Thu, Aug 25, 2011 at 8:10 AM, Dave Crozier <[email protected]>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/CAJCBksp7LWkJGZ9vW=u8nf1ldwhi7jr9r8lpts84cbwd1b8...@mail.gmail.com ** 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.
