Need some testing before I report this..
John Esak
john.esak at 21appr.com
Thu Jan 31 22:24:23 PST 2008
Hello all,
I am 100% sure of this.. but you know how that turns out... sometimes. :-)
So, I wonder if any of you who have a SCO 5.6 or 5.7 system could try this
and see if I'm right. If you get the same results, I'll pass it on to
fpsupport at .
Build a browse lookup to any detail file like this:
Lookup alias=filename k=AA i=N -nl b=(blah, blah xkey=ABC#23 prc=drp01
fil=asc,top)[blah blah ])
Meaning, I don't much care about the stuff that is blah blah... just have
the stuff you see clearly.
Then build drp01 to just have this in it.
Drp01 if: alias(1) AA ne ne AA Then: drop all
If:
Then : end
Now put a "debug on" just before the lookup line.
Then when the debugger comes on, check the record you are standing on. Which
you will be able to do at the drp01 processing. It should be the highest
record in the index... but it is not. Now, this is NOT the old PFLKNL
change that was made years ago. This just appears to put you on the first AA
record in the file. Meaning it processed all the other records already...
because, if you hit ENTER and encounter the END of this prc stub, you
immediately see the browse put up on the screen and it is correct.
You should have been placed on the highest record in the index, not the one
it gives you. The browse, however, appears correctly and is right. (Except
that we've asked for "top" and the highlight is at the very bottom. Which
in itself would bother me, but the borowse records are perfect so it's not
as big a deal as the debugger zooming through all those records without
giving you a chance to examine them. Besides, how does it know to stop? It
hasn't even hit the "drop all" line yet....?????? Very strange.
If any of you experience this, we'll send it along... and *then* we'll
figure out why the "top" directive leaves the highlight at the very bottom
of the browsed records with blank lines left *below* it in the window.
The index in the detail file is a standard "ascending" index built on the AA
key and then 8,yymd and a 5,hm fields after it. AA is an 8,* field.
I did this quickly... so if it is inscrutable, I'm sorry.... ask me
questions if you want to try this and have the big detail file and time to
do this.
Thanks,
John Esak
More information about the Filepro-list
mailing list