<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bruce Easton wrote:
<blockquote cite="mid:FDF464904AAF439E88144893387FEC7A@dospc146"
type="cite">
<pre wrap="">Nancy Palmquist wrote Wednesday, December 02, 2009 11:26 AM:
</pre>
<blockquote type="cite">
<pre wrap="">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.
It has happened twice now, and I had to start again. Counts
are different but Generating Output is no where near zero.
The processing is archiving data and everything looks exactly
right until it stops. If I select the same records again (at
least the ones that did not archive on the earlier pass) it
processes the remaining records exactly as it should.
I could understand if it threw an error or something, but
everything looks perfect.
Anyone else seen behavior like this and has some idea what
might be going on?.
BTW: Windows Server 2003, 5.0 filepro.
Nancy
</pre>
</blockquote>
<pre wrap=""><!---->
Nancy, I'm assuming that since you say archiving that
this process is deleting records (after archival)? Not that
that should be a problem, but I'm just curious about how
much is involved in that one step.
</pre>
</blockquote>
You are correct, I am taking records out of driver/key and putting
them in driver/key07 or some other qualifier.<br>
This is associated with an order and it depends on where the order was
archived. Most every record was archived to 07 because I selected
records created in 07 and stuff usually happens really fast with
orders. I check the live order data, if it is there, nothing happens,
the record is not archived. I check 07, if it is there (and it was all
but 300 times out of 21,000 records)it gets moved and ends or I check
08, and 09 and if it is not in any file, I move it to keybad. These
are orders that might have been deleted or cleared out for some reason.<br>
<br>
Simple logic really, I have done it many times. This logic has been
generalized and I copy it to all the support files that have this same
connection. <br>
<br>
<blockquote cite="mid:FDF464904AAF439E88144893387FEC7A@dospc146"
type="cite">
<pre wrap="">
Even for a simple report that didn't post or delete, my
first instinct would be to say that something jumps
unexpectedly to @done or a label after @done where it
encounters an exit--maybe even conditional on data. But
you say two runs against the same data behave differently--
so that makes me think it's something else.
</pre>
</blockquote>
This is not possible. There is no exit. Only one END and it would
just move to the next record.<br>
There are only three lines in the @DONE<br>
@DONE <br>
msgbox "Finished moving XXXXX records"<br>
end<br>
<br>
That is about it, so there is nothing to jump into.<br>
<br>
<blockquote cite="mid:FDF464904AAF439E88144893387FEC7A@dospc146"
type="cite">
<pre wrap="">
Are you archiving to qualified file of the file you're
running out of? There's that weird thing in Windows fp
about one qualifiers lock having potential of making
other locks look bad. But I would think you would get
some kind of error msg if that was the problem.
</pre>
</blockquote>
Yes I archive to qualifiers.<br>
<blockquote cite="mid:FDF464904AAF439E88144893387FEC7A@dospc146"
type="cite">
<pre wrap="">Also, does the screen go blank for quite a bit when
it bombs out? I've seen where the process is actually
finishing on windows fp, but the screen just won't
show a good bit of the last part of the count down.
</pre>
</blockquote>
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.<br>
<br>
I selected a 2 week part of the month I tried in the first crash, and
it ran to 0 as it should. I kind of watched it, out of the corner of
my eye to see if it hit that done message. Worked great.<br>
<br>
Thanks for the comments. I got nothing else. And it seems I can not
duplicate it on command. I am not going to tweak the programming any
more and need to run it a few more times. The archiving is slow on
this file and I can not have something running too long. So I will do
it by subsets until I get 2007 done.<br>
<br>
Nancy<br>
<blockquote cite="mid:FDF464904AAF439E88144893387FEC7A@dospc146"
type="cite">
<pre wrap="">Bruce
Bruce Easton
STN, Inc.
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="80">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>