Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't find frx file error
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00230993
Message ID:
00231013
Views:
16
>Heres a challenge for you!!
>
>We've had an intermittent bug that has been occurring on our test machines for about 3 months now. It started out as just a simple little "File does not exist" error, which of course didn't tell us much of anything. The error occurs occasionally when previewing or printing a report. The problem is compounded by the fact that we can't seem to get the error to repeat in developement mode in order to track it to a specific line or procedure. In response we put in a whole bunch of error handlers to give us more descriptive errors. We have finally tracked the problem to the following line (we think):
>use (tc_ReportName) alias OldReport
>where tc_ReprotName is the name of the frx file. Why would we be opening an frx table, you ask? In order to clear the tag and tag2 fields of printer information. We actually starting doing this in response to the original "File does not exist" error. The error message we get now is "File 'c:\sxxi\masschangesummary.frx' does not exist" where sxxi is the directory we are running the program out of.

You might want to check the file's existence with the FILE() function before trying to USE it...also, I assume you do a SELECT 0 or have

use (tc_ReportName) alias OldReport in 0

to not close any open tables..., that can certainly cause problems.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform