No, No, No ... General fields are the work of the devil.... bloated memo files, VFP table size restrictions, links that get mysteriously corrupted, slow as hell etc.
Better to store your binary data outside VFP in a SQL server of some type which is made for the job and/or just store links to the Binary data (Pictures, Spreadsheets etc.) Years of seeing people try general fields and eventually giving up but generating themselves loads of grief in the process has lead me to these conclusions. Even SQLExpress can now hold over 100Gb of data (May be more now) and it is free, reliable and simple to use as a road to running full SQL. We started our system this way and now host 17Tb of scanned data online. Try that with General fields!!! Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: 26 July 2016 04:46 To: profox <[email protected]> Subject: Windows 10 and Append General So I have used this approach for 20 years and it has always worked My client prepares an invoice using Word The file is "INV"+alltrim(str(invnum))+".DOC" E.g. INV12345.DOC The system says append general rtfgen from &newfile LINK It is then easy to print this on the report It seems this no longer works with Win10 My thoughts at this time are to no longer store the data in a General field, and to print the DOC file as part of the report. BUT, I can't figure how to do that. I can print pictures, BMP's, Gif's etc, but not a Doc file Can anyone throw some light on this, or offer some suggestions? -- Kind regards, Sytze de Boer --- 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://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
