frx not found

Help! I compiled an vfp9 sp2 exe which includes frx, not error during build.
Then I copy the exe to other directory and try to run it. It can not find the
included frx!

Did I missing anything? Please help!
TIA

swdev2
Sat Sep 08 16:38:44 PDT 2007

WHAT is the exact error message ?
what is the root folder of the original project ?
what is the name of the folder where the report file resides, and does it
hang off the root folder or is it totally somewhere else?
what does your PATH statement look like ? (or set path)

Regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"WT" <WT@discussions.microsoft.com> wrote in message
news:66CC1A4D-665C-46AA-A308-2555A83EF266@microsoft.com...
> Help! I compiled an vfp9 sp2 exe which includes frx, not error during
build.
> Then I copy the exe to other directory and try to run it. It can not find
the
> included frx!
>
> Did I missing anything? Please help!
> TIA

Beverly
Sat Sep 08 16:43:31 PDT 2007

Is the report form in the project?

If not, is the form explicitly called in the code or is is possible you
constructed the form name and used a macro extension... for example;

formname = "inventory" + "1"
report form &formname

You can manually add it to the project...

or, a better solution is to add an "EXTERNAL REPORT" statement in the code.

hth,
Beverly Howard

swdev2
Sat Sep 08 18:00:06 PDT 2007

Also -
YOu remember that sp2 is not released for general use yet, right?
But it's good you're using it to test with now - don't forget to post
any bug findings and reports directly with MicroSoft.

Regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"WT" <WT@discussions.microsoft.com> wrote in message
news:66CC1A4D-665C-46AA-A308-2555A83EF266@microsoft.com...
> Help! I compiled an vfp9 sp2 exe which includes frx, not error during
build.
> Then I copy the exe to other directory and try to run it. It can not find
the
> included frx!
>
> Did I missing anything? Please help!
> TIA

WT
Sat Sep 08 20:32:13 PDT 2007

Thanks for both of your replies.
Below is my coding model and hope to get you further advice,

*!* Pass to standard class
***Temporary public variable for the report header
** Parameter for report header and tmporary cursor
**
Public mCodeFrom , mCodeTo, cTmpFrx, cTmpFrt As String
mCodefrom =Alltrim(Thisform.code1.Text)
mCodeTo = Alltrim(Thisform.code.Text)

cTmpSysVal = ALLTRIM(SYS(03))
*
cTmpFrx = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frx"
cTmpFrt = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frt"

COPY FILE "r_loc.frx" TO &cTmpFrx
COPY FILE "r_loc.frt" TO &cTmpFrt

** Localize report to selected language
** SET PROCEDURE TO cRptLocalize ADDITIVE
=cRptLocalize( cTmpFrx , cTmpFrt )

**Set Procedure To cReportClass Additive
** Either Preview, Print or create Pdf file will be done in this procedure
=PrintFunction(Thisform, cTmpFrx)

If Used(cTmpDB)
Select(cTmpDB)
Use
Endif

IF FILE(cTmpFrx )
DELETE FILE &cTmpFrx
DELETE FILE &cTmpFrt
ENDIF

TIA

**====================================================









"swdev2" wrote:

> Also -
> YOu remember that sp2 is not released for general use yet, right?
> But it's good you're using it to test with now - don't forget to post
> any bug findings and reports directly with MicroSoft.
>
> Regards [Bill]
> --
> ===================
> William Sanders / EFG VFP / mySql / MS-SQL
> www.efgroup.net/vfpwebhosting
> www.terrafox.net www.viasqlserver.net
>
> "WT" <WT@discussions.microsoft.com> wrote in message
> news:66CC1A4D-665C-46AA-A308-2555A83EF266@microsoft.com...
> > Help! I compiled an vfp9 sp2 exe which includes frx, not error during
> build.
> > Then I copy the exe to other directory and try to run it. It can not find
> the
> > included frx!
> >
> > Did I missing anything? Please help!
> > TIA
>
>
>

Dan
Sun Sep 09 01:41:58 PDT 2007

What line of code fails?

WT wrote:
> Thanks for both of your replies.
> Below is my coding model and hope to get you further advice,
>
> *!* Pass to standard class
> ***Temporary public variable for the report header
> ** Parameter for report header and tmporary cursor
> **
> Public mCodeFrom , mCodeTo, cTmpFrx, cTmpFrt As String
> mCodefrom =Alltrim(Thisform.code1.Text)
> mCodeTo = Alltrim(Thisform.code.Text)
>
> cTmpSysVal = ALLTRIM(SYS(03))
> *
> cTmpFrx = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frx"
> cTmpFrt = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frt"
>
> COPY FILE "r_loc.frx" TO &cTmpFrx
> COPY FILE "r_loc.frt" TO &cTmpFrt
>
> ** Localize report to selected language
> ** SET PROCEDURE TO cRptLocalize ADDITIVE
> =cRptLocalize( cTmpFrx , cTmpFrt )
>
> **Set Procedure To cReportClass Additive
> ** Either Preview, Print or create Pdf file will be done in this
> procedure =PrintFunction(Thisform, cTmpFrx)
>
> If Used(cTmpDB)
> Select(cTmpDB)
> Use
> Endif
>
> IF FILE(cTmpFrx )
> DELETE FILE &cTmpFrx
> DELETE FILE &cTmpFrt
> ENDIF
>
> TIA
>
> **====================================================
>
>
>
>
>
>
>
>
>
> "swdev2" wrote:
>
>> Also -
>> YOu remember that sp2 is not released for general use yet, right?
>> But it's good you're using it to test with now - don't forget to post
>> any bug findings and reports directly with MicroSoft.
>>
>> Regards [Bill]
>> --
>> ===================
>> William Sanders / EFG VFP / mySql / MS-SQL
>> www.efgroup.net/vfpwebhosting
>> www.terrafox.net www.viasqlserver.net
>>
>> "WT" <WT@discussions.microsoft.com> wrote in message
>> news:66CC1A4D-665C-46AA-A308-2555A83EF266@microsoft.com...
>>> Help! I compiled an vfp9 sp2 exe which includes frx, not error
>>> during build. Then I copy the exe to other directory and try to run
>>> it. It can not find the included frx!
>>>
>>> Did I missing anything? Please help!
>>> TIA

Gregory
Sun Sep 09 01:57:36 PDT 2007

If it's the COPY FILE that fails - as I expect it to - see correction inline

"WT" <WT@discussions.microsoft.com> wrote in message
news:12D5DF70-6F64-4946-A171-B5615CD25285@microsoft.com...
> Thanks for both of your replies.
> Below is my coding model and hope to get you further advice,
>
> *!* Pass to standard class
> ***Temporary public variable for the report header
> ** Parameter for report header and tmporary cursor
> **
> Public mCodeFrom , mCodeTo, cTmpFrx, cTmpFrt As String
> mCodefrom =Alltrim(Thisform.code1.Text)
> mCodeTo = Alltrim(Thisform.code.Text)
>
> cTmpSysVal = ALLTRIM(SYS(03))
> *
> cTmpFrx = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frx"
> cTmpFrt = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frt"




> COPY FILE "r_loc.frx" TO &cTmpFrx
> COPY FILE "r_loc.frt" TO &cTmpFrt

=strtoFile(FileToStr("r_loc.frx"), m.cTmpFrx )
=strtoFile(FileToStr("r_loc.frt"), m.cTmpFrt )



> ** Localize report to selected language
> ** SET PROCEDURE TO cRptLocalize ADDITIVE
> =cRptLocalize( cTmpFrx , cTmpFrt )
>
> **Set Procedure To cReportClass Additive
> ** Either Preview, Print or create Pdf file will be done in this procedure
> =PrintFunction(Thisform, cTmpFrx)
>
> If Used(cTmpDB)
> Select(cTmpDB)
> Use
> Endif
>
> IF FILE(cTmpFrx )
> DELETE FILE &cTmpFrx
> DELETE FILE &cTmpFrt
> ENDIF
>
> TIA
>
> **====================================================

WT
Wed Sep 12 20:12:00 PDT 2007

Hi Adam, thanks for your reply.
I also suspect the the COPY FILE statement fail me . I tried to change it
with your correction, however it didn't go thru either.

error shows 'File does not exists!'

* Original code
*COPY FILE "r_loc.frx" TO &cTmpFrx
*COPY FILE "r_loc.frt" TO &cTmpFrt

*New code
=strtoFile(FileToStr("r_loc.frx"), cTmpFrx )
=strtoFile(FileToStr("r_loc.frt"), cTmpFrt )

Either I use m.cTmpFrx or cTmpFrx cause the same error.

Any idea?



"Gregory Adam" wrote:

> If it's the COPY FILE that fails - as I expect it to - see correction inline
>
> "WT" <WT@discussions.microsoft.com> wrote in message
> news:12D5DF70-6F64-4946-A171-B5615CD25285@microsoft.com...
> > Thanks for both of your replies.
> > Below is my coding model and hope to get you further advice,
> >
> > *!* Pass to standard class
> > ***Temporary public variable for the report header
> > ** Parameter for report header and tmporary cursor
> > **
> > Public mCodeFrom , mCodeTo, cTmpFrx, cTmpFrt As String
> > mCodefrom =Alltrim(Thisform.code1.Text)
> > mCodeTo = Alltrim(Thisform.code.Text)
> >
> > cTmpSysVal = ALLTRIM(SYS(03))
> > *
> > cTmpFrx = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frx"
> > cTmpFrt = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frt"
>
>
>
>
> > COPY FILE "r_loc.frx" TO &cTmpFrx
> > COPY FILE "r_loc.frt" TO &cTmpFrt
>
> =strtoFile(FileToStr("r_loc.frx"), m.cTmpFrx )
> =strtoFile(FileToStr("r_loc.frt"), m.cTmpFrt )
>
>
>
> > ** Localize report to selected language
> > ** SET PROCEDURE TO cRptLocalize ADDITIVE
> > =cRptLocalize( cTmpFrx , cTmpFrt )
> >
> > **Set Procedure To cReportClass Additive
> > ** Either Preview, Print or create Pdf file will be done in this procedure
> > =PrintFunction(Thisform, cTmpFrx)
> >
> > If Used(cTmpDB)
> > Select(cTmpDB)
> > Use
> > Endif
> >
> > IF FILE(cTmpFrx )
> > DELETE FILE &cTmpFrx
> > DELETE FILE &cTmpFrt
> > ENDIF
> >
> > TIA
> >
> > **====================================================
>
>

WT
Thu Sep 13 00:48:01 PDT 2007

Hi Adam,

Please ignore my previous post, I found the error! After applied the
function given by you it actually resolved the FRX not found issue.

But, I will need to distribute the ReportOutput.App with my compile program.

Thank you very much!

WT


"Gregory Adam" wrote:

> If it's the COPY FILE that fails - as I expect it to - see correction inline
>
> "WT" <WT@discussions.microsoft.com> wrote in message
> news:12D5DF70-6F64-4946-A171-B5615CD25285@microsoft.com...
> > Thanks for both of your replies.
> > Below is my coding model and hope to get you further advice,
> >
> > *!* Pass to standard class
> > ***Temporary public variable for the report header
> > ** Parameter for report header and tmporary cursor
> > **
> > Public mCodeFrom , mCodeTo, cTmpFrx, cTmpFrt As String
> > mCodefrom =Alltrim(Thisform.code1.Text)
> > mCodeTo = Alltrim(Thisform.code.Text)
> >
> > cTmpSysVal = ALLTRIM(SYS(03))
> > *
> > cTmpFrx = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frx"
> > cTmpFrt = ALLTRIM(_tempOutPut)+"tmp"+cTmpSysVal+".frt"
>
>
>
>
> > COPY FILE "r_loc.frx" TO &cTmpFrx
> > COPY FILE "r_loc.frt" TO &cTmpFrt
>
> =strtoFile(FileToStr("r_loc.frx"), m.cTmpFrx )
> =strtoFile(FileToStr("r_loc.frt"), m.cTmpFrt )
>
>
>
> > ** Localize report to selected language
> > ** SET PROCEDURE TO cRptLocalize ADDITIVE
> > =cRptLocalize( cTmpFrx , cTmpFrt )
> >
> > **Set Procedure To cReportClass Additive
> > ** Either Preview, Print or create Pdf file will be done in this procedure
> > =PrintFunction(Thisform, cTmpFrx)
> >
> > If Used(cTmpDB)
> > Select(cTmpDB)
> > Use
> > Endif
> >
> > IF FILE(cTmpFrx )
> > DELETE FILE &cTmpFrx
> > DELETE FILE &cTmpFrt
> > ENDIF
> >
> > TIA
> >
> > **====================================================
>
>