Raphael, I have exactly the VFP coding that you need and you can hold any document type, pictures, Word, Excel etc etc. If you want it I'll clean it up and send it to you. There are a few neat tricks you need to pull with VFP Data to get it into the format for SQL Server. I would use the newly "increased in size" Free M$ SQL server with a data capacity of 4Gb.
The classes I use also retrieve the data back into the native document type. Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: 28 May 2010 13:32 To: ProFox Email List Subject: VFP and SQL Server + Word files I have a requirement to save hundreds of Word files, with sensitive information, so only the user can read them and prevent anybody from copying them. I thought of saving them in a SQL Server database and this raises a few questions: Is this a good idea? If so, which data type in SQL Server should I use? How would this be accomplished using VFP 9 as the front end? (I need some code snippet here, both for saving and retrieving the file) Are there any alternative ways, EXCLUDING .NET, since I have not learned that yet? TIA Rafael Copquin --- 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.
