Generating Output Count

George Simon GSimon at americanriverintl.com
Thu Dec 3 08:21:37 PST 2009


I've had the same problem at one customer.  Also running Windows Server 2003 and filePro 5.0.14.
This program, (part of a vertical application) generates monthly statements. It is running perfectly in many other locations, most of them also running Windows Server 2003.  The program would select the correct amount of records and then exit without warning before finishing.  It did not always happen at the same record count.  Sometimes it would only print a couple of the selected records and exit.  Other times it would print 90% and then exit.  I tried to solve the problem for many months, even going to the customer's site and running the statements myself to make sure everything was being done properly, but I was never able to figure out what was causing it to exit without warning.  It made the running of the monthly statements a nightmare.  So bad in fact that the customer, after running my software for over 10 years, gave up and moved to something else.  I could not blame him one bit as I would have done the same thing.
One thing I did notice was that when I sent the output to a file, instead of the printer, the problem did not occur as often but it would still occur.

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Wednesday, December 02, 2009 5:20 PM
To: Nancy Palmquist
Cc: filepro-list at lists.celestial.com
Subject: Re: Generating Output Count

Nancy Palmquist wrote:
> Bruce Easton wrote:
>> Nancy Palmquist wrote Wednesday, December 02, 2009 11:26 AM:
>>  
>>> Guys,
>>>
>>> I am wondering how I got this result.
>>>
>>> I am watching a report process.  The screen displays something like:
>>>
>>> Records Selected: 29953
>>>
>>> Generating Output: 21900
>>>
>>> And all of a sudden, I get the message that is activated by @done 
>>> processing and the report ends.
[...]
>>> BTW: Windows Server 2003, 5.0 filepro.
[...]
> There is no exit.  Only one END and it would just 
> move to the next record.
> There are only three lines in the @DONE
> @DONE msgbox "Finished moving XXXXX records"
> end
> 
> That is about it, so there is nothing to jump into.

Other than the obvious "can the code above @DONE fall into @DONE" question, 
I would start by including @RS, @TS, and @RP in the @DONE message.  Of 
particular interest is what @RP shows as the number of records processed.

[...]
> Screen looked perfect.  It was just displaying the @done message, and 
> the screen still showed that there was a large number in the Generating 
> Output count.  It should have been 0.

Am I correct in assuming that pressing Enter caused *report to exit?  (ie: 
it really was done.)

[...]

-- 
Kenneth Brody



More information about the Filepro-list mailing list