Re: Windows 10 and Append General

2016-07-27 Thread Sytze de Boer
Update Thank you all for your comments/opinions or otherwise. My client has reversed the Win10 update and all is well again. i.e. same pc, same office, no change to my application. It simply fails to "append general", as in it skips this line in my code. So now I have time to apply a

Re: Windows 10 and Append General

2016-07-27 Thread mbsoftwaresolutions
On 2016-07-27 04:59, Alan Bourke wrote: I just tested this under Windows 10, VFP9 SP2 and a small table with a general field linked to Word 2016 .docx files. It seems to indeed work fine once I set the properties of the report field to 'Scale Picture - Retain Shape'. So again I would strongly

Re: Windows 10 and Append General

2016-07-27 Thread Ted Roche
In my case, I started with an invoice already in a PDF, as that's how I send them to clients. I'm a big fan of PDF for this purpose: they're not (easily) modified, the print pretty at the client's site regardless of their printers, and they make a professional appearance. Word, not so much.

Re: Windows 10 and Append General

2016-07-27 Thread Ted Roche
Okay, Sytze, Alan says it works fine. Is it possible that you are trying to run 64-bit Office from within (always 32-bit) Visual FoxPro? That might cause a problem. On Wed, Jul 27, 2016 at 4:59 AM, Alan Bourke wrote: > I just tested this under Windows 10, VFP9 SP2 and a

Re: Windows 10 and Append General

2016-07-27 Thread Man-wai Chang
That's how most do it! Storing those files outside of VFP DBF files actually improve security and ease of management. You can make use of the file sytsem's features to manage them. In the case of extreme security breaches, you could just relocate if not delete the file, instead of having to dig

Re: Windows 10 and Append General

2016-07-27 Thread Alan Bourke
I just tested this under Windows 10, VFP9 SP2 and a small table with a general field linked to Word 2016 .docx files. It seems to indeed work fine once I set the properties of the report field to 'Scale Picture - Retain Shape'. So again I would strongly suspect path resolution issues. -- Alan

Re: Windows 10 and Append General

2016-07-27 Thread Alan Bourke
On Tue, 26 Jul 2016, at 10:11 PM, Sytze de Boer wrote: > Yes, I'm trying to print the Doc file embedded in a report. Like you can > with a picture. I'm amazed that *ever* worked without getting involved in ReportListeners. -- Alan Bourke alanpbourke (at) fastmail (dot) fm

RE: Windows 10 and Append General

2016-07-27 Thread Paul Newton
To: profoxt...@leafe.com Subject: Re: Windows 10 and Append General Yes, I'm trying to print the Doc file embedded in a report. Like you can with a picture. On Wed, Jul 27, 2016 at 9:08 AM, Ted Roche <tedro...@gmail.com> wrote: > On Tue, Jul 26, 2016 at 3:56 PM, Sytze de Boer

Re: Windows 10 and Append General

2016-07-26 Thread Ted Roche
On Tue, Jul 26, 2016 at 3:56 PM, Sytze de Boer wrote: > > My remaining issue though, is there some way I can print a report with the > DOC file details.? (In much the same way as printing a report with a JPG > file, or otherwise) > I'm sorry for being dense, but what do you

Re: Windows 10 and Append General

2016-07-26 Thread Sytze de Boer
Yes, I'm trying to print the Doc file embedded in a report. Like you can with a picture. On Wed, Jul 27, 2016 at 9:08 AM, Ted Roche wrote: > On Tue, Jul 26, 2016 at 3:56 PM, Sytze de Boer > wrote: > > > > My remaining issue though, is there some way

Re: Windows 10 and Append General

2016-07-26 Thread Sytze de Boer
> -Original Message- >> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer >> Sent: 26 July 2016 04:46 >> To: profox <profox@leafe.com> >> Subject: Windows 10 and Append General >> >> So I have used this approach f

RE: Windows 10 and Append General

2016-07-26 Thread Gene Wirchenko
[reordered to chronological] At 02:26 2016-07-26, Dave Crozier <da...@flexipol.co.uk> wrote: -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: 26 July 2016 04:46 To: profox <profox@leafe.com> Subject: Windows 10 and Append G

Re: Windows 10 and Append General

2016-07-26 Thread Ted Roche
On Tue, Jul 26, 2016 at 10:03 AM, Koen Piller wrote: > And Ted yes I am with you when changing functional good running code. > However Sytze has a problem with exactly that. So in this case it is my > opinion to change completely and dont store anything in a General Field

Re: Windows 10 and Append General

2016-07-26 Thread Koen Piller
Alan I mistread sure my advise was for Sytze. And Ted yes I am with you when changing functional good running code. However Sytze has a problem with exactly that. So in this case it is my opinion to change completely and dont store anything in a General Field but change the code I am sure he will

Re: Windows 10 and Append General

2016-07-26 Thread Alan Bourke
> Alan, > > Donot store anything in GeneralFields, and if you must than donot. I don't. The original questioner did. > Just store the fullpath in of the .doc .xls or whatever file in your memo > field. I generally store a relative path beneath a defined root location and retrieve files when

Re: Windows 10 and Append General

2016-07-26 Thread Ted Roche
Well, I think the effect that Sytze was depending on was the feature of General fields that store a bitmap image of the linked OLE object in the field, suitable, in some cases, for printing. That's how the FRX report worked. It's a dangerous thing to depend on, since different OLE servers store

Re: Windows 10 and Append General

2016-07-26 Thread Koen Piller
Alan, Donot store anything in GeneralFields, and if you must than donot. Just store the fullpath in of the .doc .xls or whatever file in your memo field. Advise you to change your code and I can garantee you will be a happy foxpro user again. Regards, Koen 2016-07-26 9:46 GMT+02:00 Alan Bourke

Re: Windows 10 and Append General

2016-07-26 Thread Ted Roche
Sytze: As you're coming to learn, depending on Microsoft to maintain their APIs and compatibility from version to version is a gamble. Unless there's some reason the client wants to edit their invoices after sending, rather than saving in Word, have them save a PDF file. Test out your code to

RE: Windows 10 and Append General

2016-07-26 Thread Dave Crozier
/products. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 26 July 2016 11:17 To: profoxt...@leafe.com Subject: Re: Windows 10 and Append General Dave Crozier wrote: > Even SQLExpress can now hold over 100Gb of data Currently it is 1

Re: Windows 10 and Append General

2016-07-26 Thread Alan Bourke
Dave Crozier wrote: > Even SQLExpress can now hold over 100Gb of data Currently it is 10GB per database, you can have as many databases as disk space allows. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Windows 10 and Append General

2016-07-26 Thread Dave Crozier
<profox@leafe.com> 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 f

RE: Windows 10 and Append General

2016-07-26 Thread Allen Pollard
Not saving in Program files are you? That's a no no now. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 26 July 2016 09:47 To: profoxt...@leafe.com Subject: Re: Windows 10 and Append General > It seems this no longer wo

Re: Windows 10 and Append General

2016-07-26 Thread Alan Bourke
> It seems this no longer works with Win10 I don't know why it wouldn't work with Windows 10 other than you are linking it and it can't resolve the path in the link. If you do MODIFY GENERAL does it bring up the .DOC? Frankly I'm surprised it worked on a report layout in *any* OS. The help

Re: Windows 10 and Append General

2016-07-26 Thread Man-wai Chang
I don't use the GENERAL data type in VFP. I always think It's better to store binary data outside of DBF. On Tue, Jul 26, 2016 at 11:46 AM, Sytze de Boer wrote: > So I have used this approach for 20 years and it has always worked > My client prepares an invoice using Word >

Re: Windows 10 and Append General

2016-07-25 Thread Mike Copeland
Here's (possibly) some helpful info. I have a client that I upgraded from Win7 to 10, and he uses Excel a LOT. There's a website that he goes to and they have a link he clicks that downloads a collection of data that is autoloaded from the browser into Excel. Well, after working for years

Windows 10 and Append General

2016-07-25 Thread Sytze de Boer
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 LINK It is then easy to print this on the report It seems this no longer works