I have written a membership system for a local organisation. I decided to add a facility to email a membership card to a member instead of posting it. I created a report which consists of a jpg image containing the background and base text, a scan of the original blank card, with 3 fields superimposed to hold name, membership no and expiry date. The image is in the page header section as it uses global variables for the data; I tried putting it in the body and using a single record cursor but the system insisted on producing three cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP as an app it works perfectly but when I run it from the exe the report contains the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you copy it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided to add a facility to email a membership card to a member instead of posting it. I created a report which consists of a jpg image containing the background and base text, a scan of the original blank card, with 3 fields superimposed to hold name, membership no and expiry date. The image is in the page header section as it uses global variables for the data; I tried putting it in the body and using a single record cursor but the system insisted on producing three cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP as an app it works perfectly but when I run it from the exe the report contains the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
Hi Tracy,
Not sure what you mean by *copy it out*. For development purposes I put everything in a set of sub-folders within a single main folder. The data is in one sub-folder and the source code, including the image, is in another sub-folder. Both the app and the exe sit next to one another inside the main folder so the path to the image is identical.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 19:09 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you
copy
it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided to
add
a facility to email a membership card to a member instead of posting it. I created a report which consists of a jpg image containing the background and base text, a scan of the original blank card, with 3 fields
superimposed to
hold name, membership no and expiry date. The image is in the page header section as it uses global variables for the data; I tried putting it in
the body
and using a single record cursor but the system insisted on producing
three
cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP as an app it works perfectly but when I run it from the exe the report
contains
the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
Hi John,
Try opening your FRX file as a table then browse for the image record:
BROWSE FOR objtype=17 FIELDS picture
Open up the memo field and look at the exact path and name of the image:
for example:
"..\yourimage.jpg"
How is it relative to your main folder file placements and subfolder where it is stored?
-Philip B.
On 8/7/2017 2:53 PM, John Weller wrote:
Hi Tracy,
Not sure what you mean by *copy it out*. For development purposes I put everything in a set of sub-folders within a single main folder. The data is in one sub-folder and the source code, including the image, is in another sub-folder. Both the app and the exe sit next to one another inside the main folder so the path to the image is identical.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 19:09 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you
copy
it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided to
add
a facility to email a membership card to a member instead of posting it. I created a report which consists of a jpg image containing the background and base text, a scan of the original blank card, with 3 fields
superimposed to
hold name, membership no and expiry date. The image is in the page header section as it uses global variables for the data; I tried putting it in
the body
and using a single record cursor but the system insisted on producing
three
cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP as an app it works perfectly but when I run it from the exe the report
contains
the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
Hi Philip,
That shows up the problem. I was creating the exe in the source code folder then moving it up a level before running it whereas the app was created at the same level as it was being run at. It's never caused a problem before, I'll have to see how it works outside the development environment now :-)
Thanks
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip Borkholder Sent: 07 August 2017 21:35 To: profoxtech@leafe.com Subject: Re: Report Anomaly
Hi John,
Try opening your FRX file as a table then browse for the image record:
BROWSE FOR objtype=17 FIELDS picture
Open up the memo field and look at the exact path and name of the image:
for example:
"..\yourimage.jpg"
How is it relative to your main folder file placements and subfolder where
it is
stored?
-Philip B.
On 8/7/2017 2:53 PM, John Weller wrote:
Hi Tracy,
Not sure what you mean by *copy it out*. For development purposes I put everything in a set of sub-folders within a single main folder. The
data is
in one sub-folder and the source code, including the image, is in
another
sub-folder. Both the app and the exe sit next to one another inside the main folder so the path to the image is identical.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 19:09 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you
copy
it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided
to
add
a facility to email a membership card to a member instead of posting
it.
I created a report which consists of a jpg image containing the
background
and base text, a scan of the original blank card, with 3 fields
superimposed to
hold name, membership no and expiry date. The image is in the page
header
section as it uses global variables for the data; I tried putting it in
the body
and using a single record cursor but the system insisted on producing
three
cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP
as
an app it works perfectly but when I run it from the exe the report
contains
the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
I hope that solves it John.
I've had the same issues before so it rang a bell. :-)
All the best!
-Philip B.
On 8/7/2017 5:07 PM, John Weller wrote:
Hi Philip,
That shows up the problem. I was creating the exe in the source code folder then moving it up a level before running it whereas the app was created at the same level as it was being run at. It's never caused a problem before, I'll have to see how it works outside the development environment now :-)
Thanks
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip Borkholder Sent: 07 August 2017 21:35 To: profoxtech@leafe.com Subject: Re: Report Anomaly
Hi John,
Try opening your FRX file as a table then browse for the image record:
BROWSE FOR objtype=17 FIELDS picture
Open up the memo field and look at the exact path and name of the image:
for example:
"..\yourimage.jpg"
How is it relative to your main folder file placements and subfolder where
it is
stored?
-Philip B.
On 8/7/2017 2:53 PM, John Weller wrote:
Hi Tracy,
Not sure what you mean by *copy it out*. For development purposes I put everything in a set of sub-folders within a single main folder. The
data is
in one sub-folder and the source code, including the image, is in
another
sub-folder. Both the app and the exe sit next to one another inside the main folder so the path to the image is identical.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 19:09 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you
copy
it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided
to
add
a facility to email a membership card to a member instead of posting
it.
I created a report which consists of a jpg image containing the
background
and base text, a scan of the original blank card, with 3 fields
superimposed to
hold name, membership no and expiry date. The image is in the page
header
section as it uses global variables for the data; I tried putting it in
the body
and using a single record cursor but the system insisted on producing
three
cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP
as
an app it works perfectly but when I run it from the exe the report
contains
the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
John,
What I mean by "copy it out". You can FILETOSTR(STRTOFILE()) to copy a known Included file out of the currently running EXE to the physical drive.
Otherwise, you can just distribute the external files.
Tracy
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:54 PM To: profox@leafe.com Subject: RE: Report Anomaly
Hi Tracy,
Not sure what you mean by *copy it out*. For development purposes I put everything in a set of sub-folders within a single main folder. The data is in one sub-folder and the source code, including the image, is in another sub-folder. Both the app and the exe sit next to one another inside the main folder so the path to the image is identical.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 19:09 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
Is the image in a relative path to the report. The image needs to be on the disk, not in the executable. *(unless you
copy
it out)*
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Monday, August 07, 2017 2:00 PM To: profoxtech@leafe.com Subject: Report Anomaly
I have written a membership system for a local organisation. I decided to
add
a facility to email a membership card to a member instead of posting it. I created a report which consists of a jpg image containing the background and base text, a scan of the original blank card, with 3 fields
superimposed to
hold name, membership no and expiry date. The image is in the page header section as it uses global variables for the data; I tried putting it in
the body
and using a single record cursor but the system insisted on producing
three
cards on the same sheet for some reason. The card is produced as a PDF using FoxyPreviewer and sent as an attachment. When I run it from VFP as an app it works perfectly but when I run it from the exe the report
contains
the data but not the background image.
I'm baffled! Any suggestions would be gratefully received :-)
John
John Weller 01380 723235 07976 393631
[excessive quoting removed by server]
On 2017-08-07 17:36, Tracy Pearson wrote:
John,
What I mean by "copy it out". You can FILETOSTR(STRTOFILE()) to copy a known Included file out of the currently running EXE to the physical drive.
Otherwise, you can just distribute the external files.
Tracy
Tracy,
Don't you have that backwards? Shouldn't it be STRTOFILE(FILETOSTR())?
Mike,
Yes, I did write it backwards.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Monday, August 07, 2017 7:20 PM To: profoxtech@leafe.com Subject: RE: Report Anomaly
On 2017-08-07 17:36, Tracy Pearson wrote:
John,
What I mean by "copy it out". You can FILETOSTR(STRTOFILE()) to copy a known Included file out of the currently running EXE to the physical drive.
Otherwise, you can just distribute the external files.
Tracy
Tracy,
Don't you have that backwards? Shouldn't it be STRTOFILE(FILETOSTR())?
[excessive quoting removed by server]
Now I understand! Neat idea!
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy Pearson Sent: 07 August 2017 22:37 To: profoxtech@leafe.com Subject: RE: Report Anomaly
John,
What I mean by "copy it out". You can FILETOSTR(STRTOFILE()) to copy a known Included file out of the currently running EXE to the physical drive.
-
John Weller -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Philip Borkholder -
Tracy Pearson