Changing a field in the index you're in
Jay Ashworth
jra at baylink.com
Mon Mar 9 13:59:22 PDT 2015
That sounds too simple.
Probably cause the data is being added in realtime. Hmm. Maybe not.
On March 9, 2015 4:17:13 PM EDT, Jim Asman <jlasman at telus.net> wrote:
>
>How about building a demand index and running the operation from it?
>
>--------------- Original Message ---------------
>At 01:46P Mon Mar 09 2015, Jay Ashworth wrote:
>
>> Here's a problem I had to solve 20 years ago, and I no longer have
>that
>> code on a readable drive, so I have to solve it again. Suggestions
>welcome.
>>
>> I have a user in a file via a browse on index P, which includes the
>fields
>>
>> Student ID
>> Match Percentage Descending
>>
>> So all the records with no Student ID come first, with the best
>matches at
>> the top, and the ones which the earlier matching process got hits on
>are
>> later, in order by Student ID (since that's obviously a unique key;
>the
>> fact that there's a subordinate sort is immaterial).
>>
>> The user's job is to go into the first record, and work their way
>through
>> the matches as the index presents them to them, using an @key process
>to
>> pick an existing student from a browse into the student file, or 'N'
>to
>> create a new student ID and automatically set that as the match.
>>
>> My plan was to have the accepting of a match automatically move the
>user
>> along to the next record in the index, until they run out -- there
>will
>> generally be a dozen or two records a day in this file, which are
>> archived after posting.
>>
>> Old hands at filepro will already have spotted the bug in this
>process, but
>> for those who are on my lawn (:-), it is this:
>>
>> The index I'm moving along *contains the field I'm changing*, and
>filePro
>> does not cache the "next" and "previous" record pointers *by record
>number*
>> when it arrives at a record, it figures them out when you try to use
>them.
>>
>> So once I change that Student ID, my current position along the index
>skips
>> to wherever that puts me, way down; if I add a new one, I go to the
>bottom.
>>
>> And therefore, I have to make my user do a metric shitload of manual
>nav.
>>
>> This is bad.
>>
>> When I tripped over this in 96, in a similar Run The Batch situation,
>while
>> I don't remember how I fixed it, I *do* remember passing a pissy
>comment in
>> my source identifying exactly what line of the filePro sources causes
>it --
>> that client had been a porting site for the AT&T 3b2 port, and had
>complete
>> 4.1 sources on their machine. :-)
>>
>> I'm having trouble figuring out how to fix it again, and I'm hoping
>someone
>> has had to do so more recently. (Well, I was *actually* hoping that
>having
>> to explain it to the teddybear would magically bring me the answer,
>but not
>> yet, alas.)
>>
>> Any ideas, folks?
>>
>> In a related story: has anyone ever *depended on this behavior*, such
>that
>> they would break things if they 'fixed' it?
>>
>> Cheers,
>> -- jra
>>
>> --
>> Jay R. Ashworth Baylink
>jra at baylink.com
>> Designer The Things I Think
>RFC
>2100
>> Ashworth & Associates http://www.bcp38.info 2000 Land
>Rover
>DII
>> St Petersburg FL USA BCP38: Ask For It By Name! +1 727
>647
>1274
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>Jim
>--
>jlasman at telus.net Spectra Colour Services Ltd.
>Phone: (604)584-0977 Surrey, BC CANADA
> Cell: (604)619-0977 www.spectracolorservices.com
--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20150309/f140cf85/attachment.html>
More information about the Filepro-list
mailing list