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