On Fri, Nov 12, 2010 at 7:19 AM, Rafael Copquin <[email protected]> wrote: > That's what I'm doing now, but the requirement I have is to keep access > to the word files limited to only a few selected users. And it is very > easy for anybody to simply click on a word document and view it. So that > is why I thought of saving the doc files into a SQL Server database and > then retrieve them by only those users authorized to see them. FWIW, > those files contain cosmetics and perfumes formulae that the company is > adamant should be kept secret at all costs. ----------------
Do you have to search for text inside any of the Doc files? >From VFP I do not think that you can convert the data between the types that you want to use in sending the file to SQL. Here is how I could do it in C# and I am taking advantage of the filestream for the transport of the doc. In essence I am converting the .doc file to a byte array, passing the array and inserting from that at the adapter. I don't think that VFP has that ability to generate the byte array native. You might find it in the WIN32 library site? Varbinary is a better storage data type for this file type ".doc". -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
