browse lookup phenomenon
Dennis Malen
dmalen at malen.com
Thu Mar 23 11:41:02 PST 2006
Before you read this e-mail you should open it up to a full screen in order
to view the information I have provided.
Here's a copy of the first screen:
ZDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD?
3 Rec No Type Bank Sent Returned Result Held 3
CDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD4
3 119990 RN Bank Of Am 02/09/06 3
3 119990 RN Municipal 02/09/06 3
3 119990 RN Jp Morgan 02/22/06 03/15/06 Y 3
3 119990 IS North Fork 02/23/06 3
3 119996 RN Office Of 03/06/06 3
3 119996 RN Washington 03/06/06 3
3 119996 RN Citibank, 03/06/06 3
3 119996 RN Hsbc Bank 03/06/06 3
3 119996 RN Bank Of Am 03/06/06 3
3 119996 RN Municipal 03/06/06 3
3 119996 IS Ny Tel 03/06/06 3
3 119996 IS Aetna 03/06/06 3
3 119996 IS Iverson & 03/06/06 3
3 119996 RN Astoria Fe 03/23/06 E 3
@DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDY
Please note that the higher record numbers appear at the bottom of the
screen. That is correct. Please also note that the browse lookup also
displays at the top the next lower record number. The bottom is 119996 and
the top is 119990. This should not be. If executed in input processing it
would just show record 119996, which was the record requested on an exact
match.
Here is the same screen when I scroll up and then scroll back down:
ZDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD?
3 Rec No Type Bank Sent Returned Result Held 3
CDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD4
3 119990 RN Flatbush F 02/07/06 3
3 119990 RN Marathon N 02/07/06 3
3 119990 RN Ridgewood 02/07/06 3
3 119990 IS Paychex 02/07/06 3
3 119990 RN Washington 02/09/06 3
3 119990 RN Citibank, 02/09/06 3
3 119990 RN Hsbc Bank 02/09/06 3
3 119990 RN Bank Of Am 02/09/06 3
3 119990 RN Municipal 02/09/06 3
3 119990 RN Jp Morgan 02/22/06 03/15/06 Y 3
3 119990 IS North Fork 02/23/06 3
3 119996 RN Office Of 03/06/06 3
3 119996 RN Washington 03/06/06 3
3 3
@DEnd of FileDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDY
We now see that only two of the 119996 records show. You can not scroll back
down any further to view the initial records shown. You can do this in input
processing. Also note that I can continue to scroll up into other files but
I can never scroll back down.
The following is how the browse lookup was created. Hopefully I'm not doing
anything wrong here as the processing for the browse lookup was just copied
over from input processing where the browse lookup works fine.
Lookup From File: msxrn ~
Name Of Lookup Is: ~
How Is The Record To Be Found? k~ K - Key Field R - Record Number
F - Free Record Z - Fuzzy Search
What Index Is To Be Used: A~ F6 for list
What Field In 'msx' rn ~
Contains The Key?
Protect Record in Lookup File? Y~
If Key Doesn't Match Exactly: x~ X - Key Must Match Exactly
G - Use Next Greater Match
L - Use Next Lower Match
If Lookup Fails: n~ B - Blank The Field
N - Do Nothing
E - Report An Error
Create Browse Lookup? Y~
Browse Header:
Rec No Type Bank Sent Returned Result Held
~
Browse Format:
*1 *2 *3 *4 *5 *6 *at
~
Browse Window: Lines: 18~ Row: 2~ Col: 2~
Pop-Up Screen: Name: fill ~ Row: ~ Col: ~
Only Show Records That Match Key? Y~ Y-Yes, N-No, P-show Partial match
Browse Window Show option: K~ O - Show Only. Accept no
keystrokes
(Leave blank for default) K - Keep Browse Window on Screen.
P - Retain Position on
re-execution
Exit Keys: ~
(Leave blank for none)
Order of Records (Ascending, Descending): A~
Position of First Record (Top,Bottom): B~
Processing Label: ~
Again, the foregoing works correctly in "input". It works incorrectly as
above when executed by the use of "chain", "call" or with the use of -z and
the @key.
My version of filePro is 4.8.14D4.
Let me know if there is anything more that you need.
Thanks again,
Dennis Malen
516.479.5912
More information about the Filepro-list
mailing list