Re: Windows 10 and Append General

[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 work-around.





On Thu, Jul 28, 2016 at 9:05 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> 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 suspect path resolution issues.
>>
>
>
> Ever since folks long ago suggested to NOT embed files into General fields
> (but rather store the LINK to the file instead), I avoided using General
> fields.
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cag1nny81tm+0lnxyhr5etb0-hftw08njebqxz3iyxpkgfbt...@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.

Re: Windows 10 and Append General

[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 suspect path resolution issues.



Ever since folks long ago suggested to NOT embed files into General 
fields (but rather store the LINK to the file instead), I avoided using 
General fields.


___
Post Messages to: ProFox@leafe.com
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/d9e0fd264537d5bb74ef4d8379609...@mbsoftwaresolutions.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.

Re: Windows 10 and Append General

[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.

Here's what I did to get an invoice to display on a report:

CREATE TABLE example FREE (examplepk i autoinc, invoice g)
APPEND BLANK
APPEND GENERAL invoice from sampleinvoice.pdf LINK
CREATE REPORT example FROM example.dbf
REPORT FORM example preview
MODIFY REPORT example
* Add in the general field and mess around with layout settings,
settling on "Clip Contents"
* The report shows up with a big blue 'e' -- a classic error message!
This is the icon for Windows Edge,
* in this case, the default PDF handler for Win10.
* Visit the Adobe site, download the Adobe Reader DC and follow the
prompts to make it the default handler.
* REPEAT the Append General step (since the first general field is
linked to Edge) and Preview the Report.
* Voila! WYSIWYG Invoice on a report form in six lines of code.



On Wed, Jul 27, 2016 at 7:17 AM, Ted Roche  wrote:
> 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 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 Bourke
>>   alanpbourke (at) fastmail (dot) fm
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cacw6n4s04_ktjph9quc_aduffxwfmztsbs86t_oph25xcio...@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.

Re: Windows 10 and Append General

[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 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 Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/CACW6n4sGuxv=+2nerjmuf59xbkawwpkmyerv0i0wqtox7oy...@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.

Re: Windows 10 and Append General

[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 into a
GENERAL data type. Remember: it takes time to search then bang.mp3 a
record in DBF!

On Wed, Jul 27, 2016 at 3:50 PM, Paul Newton  wrote:
> Yes, if you have the full path to the document file name you can use
> shellexecute to print it ...
> but you _might_ have to contend with a print dialog popping up

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
Post Messages to: ProFox@leafe.com
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/CAGv=mjaqhh8bsxaeov6dlvtpe5k3wpfmfghpq2jakpphttb...@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.

Re: Windows 10 and Append General

[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 Bourke
  alanpbourke (at) fastmail (dot) fm

___
Post Messages to: ProFox@leafe.com
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/1469609964.1646771.678032361.1b549...@webmail.messagingengine.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.

Re: Windows 10 and Append General

[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

___
Post Messages to: ProFox@leafe.com
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/1469607838.1640061.678006505.6c002...@webmail.messagingengine.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.

RE: Windows 10 and Append General

[Paul Newton]

Yes, if you have the full path to the document file name you can use 
shellexecute to print it ... but you _might_ have to contend with a print 
dialog popping up

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de 
Boer
Sent: 26 July 2016 22:12
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 <sytze.k...@gmail.com>
> 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 mean by that?
>
> Are DOC file details the author's name and number of characters, e.g., 
> the properties, or
>
> Are you trying to print the DOC file, perhaps as an image embedded in 
> a FoxPro FRX report?
>
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/9a8106afb0ef9b44b69045c4448935a2014124b...@nlbawexmbx1.infor.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.

Re: Windows 10 and Append General

[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 mean by that?

Are DOC file details the author's name and number of characters, e.g.,
the properties, or

Are you trying to print the DOC file, perhaps as an image embedded in
a FoxPro FRX report?


-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
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/cacw6n4uyh+bedokgsq6pzsbazkskk9zt5h36gxasgqowzzo...@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.

Re: Windows 10 and Append General

[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 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 mean by that?
>
> Are DOC file details the author's name and number of characters, e.g.,
> the properties, or
>
> Are you trying to print the DOC file, perhaps as an image embedded in
> a FoxPro FRX report?
>
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cag1nny-gsinzhjvfurvhmjs_kmefa-2jpusrq2hvj2ml1+e...@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.

Re: Windows 10 and Append General

[Sytze de Boer]

Thank you all for your opinions/advice.

I am happy to NOT store data in the General field, since the data is
already saved in DOC format, which is unique to each invoice.
("INV"+alltrim(str(invnum))+".DOC"

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)



On Wed, Jul 27, 2016 at 5:29 AM, Gene Wirchenko  wrote:

> [reordered to chronological]
>
> At 02:26 2016-07-26, Dave Crozier  wrote:
>
> -Original Message-
>> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
>> Sent: 26 July 2016 04:46
>> To: profox 
>> 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
>>
>
>  Not a solution to your problem, but you might try
>   transform(invnum)
> instead of the alltrim(str()).
>
>
> 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.
>>
>
>  One advantage of general fields is that the short form of the keyword
> is my first name.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cag1nny8xaysyzqcpxygh89pcrwv3m6gvcp2a1dchg1bww6d...@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.

RE: Windows 10 and Append General

[Gene Wirchenko]

[reordered to chronological]

At 02:26 2016-07-26, Dave Crozier  wrote:


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
Sent: 26 July 2016 04:46
To: profox 
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


 Not a solution to your problem, but you might try
  transform(invnum)
instead of the alltrim(str()).


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.


 One advantage of general fields is that the short form of the 
keyword is my first name.


Sincerely,

Gene Wirchenko


___
Post Messages to: ProFox@leafe.com
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/1bbb3a8a16ed6f36aeca39b9df31e3a6@mtlp86
** 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.

Re: Windows 10 and Append General

[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 but
> change the code I am sure he will solve his problem that way.
> Koen

We are in agreement more than not. My solution might fix his problem
today; your solution, forever.


-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
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/cacw6n4suxxe+xxgcdzinjb0bmsppvb-_tt5re11adbf4y87...@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.

Re: Windows 10 and Append General

[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 solve his problem that way.
Koen

Op dinsdag 26 juli 2016 heeft Alan Bourke  het
volgende geschreven:

> > 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 needed as root location + relative path.
>
> Storing a full UNC path or (shudder) path with a drive letter is a bad
> idea because you'll have to re-path everything when the server changes
> or the data\external files are otherwise moved, or file shares change.
> If you do it the way described above you only have to change the root
> location definition in one place.
>
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cacuu1su5xpq6lmflt2hbqagtxw_wmw1xbcrsp9ketyep6v2...@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.

Re: Windows 10 and Append General

[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 needed as root location + relative path.

Storing a full UNC path or (shudder) path with a drive letter is a bad
idea because you'll have to re-path everything when the server changes
or the data\external files are otherwise moved, or file shares change.
If you do it the way described above you only have to change the root
location definition in one place.



-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

___
Post Messages to: ProFox@leafe.com
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/1469540819.1424102.677168713.53f3b...@webmail.messagingengine.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.

Re: Windows 10 and Append General

[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
different kinds of bitmaps -- some just put the application's icon in
the General field, others store a hi-res image that takes up huge
amounts of space.

There are definitely different ways of getting the effect Sytze's
after, but I'm a big fan of minimizing changes in production code in
the field, and most of the solutions would entail a new way of
generating, storing and producing reports, which is likely too costly
if a quick workaround is available.

On Tue, Jul 26, 2016 at 8:39 AM, Koen Piller  wrote:
> 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 :
>
>> > 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
>> states:
>>
>> "If the General field in the table contains data other than an image
>> file, such as a Microsoft Excel or Microsoft Word document, an icon
>> representing that data appears on the report or label when you generate
>> output for it. "
>>
>> Are you saying it would actually print the contents of the .DOC
>> previously ?
>>
>> I assume the PC has 32-bit MS Word installed ?
>>
>>
>> --
>>   Alan Bourke
>>   alanpbourke (at) fastmail (dot) fm
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cacw6n4un0guh4zne_0tbxvhq3f34w82smogdcbpxcvmqmsx...@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.

Re: Windows 10 and Append General

[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 :

> > 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
> states:
>
> "If the General field in the table contains data other than an image
> file, such as a Microsoft Excel or Microsoft Word document, an icon
> representing that data appears on the report or label when you generate
> output for it. "
>
> Are you saying it would actually print the contents of the .DOC
> previously ?
>
> I assume the PC has 32-bit MS Word installed ?
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/cacuu1su9uvuuwpgvwpgd819ztghnnz_k07rzsdnfcgwnbd2...@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.

Re: Windows 10 and Append General

[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 see if you can work with that. That's likely the
quickest and simplest solution: get out of Office formats!

Second point, don't use '&' unless you absolutely have to: the '&' is
shorthand for "recompile this entire line using the values at runtime"
and invokes the entire parser and compiler. It is slower, and it also
chokes if there are spaces or some special characters in the file
name. Most of the time, you can use the parentheses () when just
substituting a filename into a command.

https://msdn.microsoft.com/en-us/library/4kxhy0aa(v=vs.80).aspx

http://www.tomorrowssolutionsllc.com/Articles/Handling%20Code%20that%20Changes%20at%20Runtime.pdf



On Mon, Jul 25, 2016 at 11:46 PM, 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
> 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 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: ProFox@leafe.com
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/cacw6n4tczwkd1u3avkj5822_lvm0wjhft2mdwsafbhz76sb...@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.

RE: Windows 10 and Append General

[Dave Crozier]

Alan,
That is what I meant to say!!!. 

The majority of apps I have ever written tend to use a single database anyhow 
and I must admit I prefer SQLExpress to MySQL (MariaDB) and/or its derivatives 
because of its ease of installation and seamless integration into other 
Microsoft languages/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 10GB per database, you can have as many databases as disk space 
allows.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/18725b8cd2d5d247873a2baf401d4ab290220...@ex2010-a-fpl.fpl.LOCAL
** 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.

Re: Windows 10 and Append General

[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: 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/1469528249.440079.676996049.7e704...@webmail.messagingengine.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.

RE: Windows 10 and Append General

[Dave Crozier]

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:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
Sent: 26 July 2016 04:46
To: profox 
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  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: ProFox@leafe.com
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/18725b8cd2d5d247873a2baf401d4ab290220...@ex2010-a-fpl.fpl.LOCAL
** 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.

RE: Windows 10 and Append General

[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 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
states: 

"If the General field in the table contains data other than an image
file, such as a Microsoft Excel or Microsoft Word document, an icon
representing that data appears on the report or label when you generate
output for it. " 

Are you saying it would actually print the contents of the .DOC
previously ?

I assume the PC has 32-bit MS Word installed ?


-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
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/001a01d1e717$796d5f10$6c481d30$@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.

Re: Windows 10 and Append General

[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
states: 

"If the General field in the table contains data other than an image
file, such as a Microsoft Excel or Microsoft Word document, an icon
representing that data appears on the report or label when you generate
output for it. " 

Are you saying it would actually print the contents of the .DOC
previously ?

I assume the PC has 32-bit MS Word installed ?


-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
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/1469519217.413397.676886281.29803...@webmail.messagingengine.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.

Re: Windows 10 and Append General

[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
> The file is "INV"+alltrim(str(invnum))+".DOC"
> E.g. INV12345.DOC
> The system says
> append general rtfgen from  LINK

 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
Post Messages to: ProFox@leafe.com
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/CAGv=MJCkH6WBXiaUG=zSQXJK+A2c8LzDv1B6d=efajt9cjx...@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.

Re: Windows 10 and Append General

[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 with Win7, now with Win10 he 
clicks and the web page opens Excel, but there's no data.


I haven't solved the problem yet, but I suspect that a registry link 
that connects data types (i.e., CSV) is no longer there or it's broken. 
So, I'm going to uninstall and reinstall Office on Win10 to see if that 
solves the linkage problem.


My point being that your app was probably depending on some connection 
provided by the registry (provided by the installation of Word) that is 
now broken.


Hope that helps somehow.

Mike

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
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 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?




___
Post Messages to: ProFox@leafe.com
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/4696970d-12be-1f6c-25d7-06cca492c...@ggisoft.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.