FW: Browse lookup - odd behavior
GCC Consulting
gcc at optonline.net
Wed Jul 14 19:46:35 PDT 2004
This is a response to my own post.
I Spoke with Ray Hoover today - see below
Ray,
Per my call.
Situation:
Fp 5.0.11 native
Order header & detail files.
When in the order header and listing the order details associated with the order
through a browse lookup based on the order number, when a detail line is deleted
and the browse is then re-executed, periodically an order detail from another
order will appear in the browse window.
>From what I have found out, the errant detail line is from a new order which is
being entered.
Yes, the problem can be solved by using a drop any details where the
order_numbers don't match.
Any idea why this is happening?
This is what I was advised may be causing this problem. The answer came from
Ken and I hope I am explaining it correctly.
When using pkeep in a browse, the browse keeps track of the records being
displayed by record number.
So, when a detail record is deleted, using a write and sync, and another order
is being entered, it is possible that the new order detail record is the one
just deleted.
When the browse is re-executed, the newly entered line for another order
appears either as the first or last item in the browse window as the record # is
still a valid record even though it is not for my current order.
I added a drop routine to check that all records are for the current order.
Based on the speed of today's computers it may seem a little far fetched for a
record to be deleted and an instant later be grabbed by another person doing
order entry and having that new detail display in browse window for a
completely different order. But this has happened more then once at this site.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list