Knowledge Base

FIX: Browse Key Record Pointer Moves Incorrectly

Article ID: 129913

Article Last Modified on 12/3/2003

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

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

Issue this command:
```
   BROWSE KEY "CA"
```
Close the Browse window, and issue these commands:
```
   GO TOP
   BROWSE KEY "CA"
```
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