Microsoft KB Archive/129913

From BetaArchive Wiki

Article ID: 129913

Article Last Modified on 12/3/2003



APPLIES TO

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft Visual FoxPro 3.0b Standard Edition
  • Microsoft FoxPro 2.6a Standard Edition
  • Microsoft FoxPro 2.6a Standard Edition
  • Microsoft FoxPro 2.6a Professional Edition for Macintosh
  • Microsoft FoxPro 2.6 for SCO/UNIX



This article was previously published under Q129913

SYMPTOMS

The Record Pointer moves to the last record in a Browse window when the Browse window is initially activated. The Record Pointer moves to the last record even if the GO TOP command is issued before or after the Browse window is activated. This situation occurs if both of the following conditions are true:

  • The Table being browsed is indexed in Descending Order.
  • The Browse is activated using the KEY clause with the Browse command.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. The problem has been fixed in Visual FoxPro 5.0.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the Customer table in the Tutorial directory under the Main FoxPro directory and Index it using this code:

       USE FoxPro\Tutorial\Customer.dbf
    
       && For FoxPro v2.6 for UNIX use the following command
       && USE \usr\FoxPro\tutorial\customer.dbf
    
       INDEX ON State TAG State DESCENDING
  2. Issue this command:

       BROWSE KEY "CA"
  3. Close the Browse window, and issue these commands:

       GO TOP
       BROWSE KEY "CA"
  4. With the Browse window open, issue "GO TOP" command from the Command window, and then re-select the Browse window.



Additional query words: 2.60 2.60a 3.00 3.00b

Keywords: kbbug kbfix kbvfp500fix KB129913