The information in this article applies to:
- Microsoft FoxPro for Windows versions 2.5, 2.5a, 2.5b, 2.6, 2.6a
SYMPTOMS
When a List popup is defined with the PROMPT FIELD option in the Screen
Builder, and the field displayed in the list box is the key field for that
database and contains duplicate records, the navigation buttons no longer
function when a duplicate field is reached.
RESOLUTION
To resolve the problem of the navigation buttons hanging in the list
popup, you must ensure that the record values in the field referenced in
the list are unique for each record in the file.
STATUS
Microsoft has confirmed this to be a problem in FoxPro versions 2.5 and
2.6 for Windows. We are researching this problem and will post new
information here in the Microsoft Knowledge Base as it becomes
available.
MORE INFORMATION
Steps to Reproduce Problem
- Use the CUSTOMER database in the Tutorial subdirectory.
- Create a new screen and use the Quick Screen option from the Screen
Menu to insert all the fields.
- Create a List popup from the Screen Builder toolbar in Windows.
- Select the From Field option in the List Items dialog box.
- Choose the COMPANY field from the CUSTOMER database.
- Place COMPANY as the variable for the list.
- Size the field on the screen.
- Create push button controls on the screen for top, next, prior, and
bottom ensuring that the SHOW GETS command is in the VALID.
- From the Database Menu, choose Setup.
- Create an Index Key for the COMPANY field and set the order to the
key.
- Close and exit the Database Menu by pressing the OK push button.
- From the Screen Menu, choose Screen Layout.
- Choose the Save option of the Environment dialog box.
- Press the OK push button to return to the screen.
- From the Program Menu, choose Generate.
- Select the File Menu menu and Close File option.
- Use the CUSTOMER database from the command window or File Open
dialog box.
- From the Command Window, type the following commands:
SCATTER MEMVAR
APPEND BLANK
GATHER MEMVAR
USE
- From the Run Menu, choose Screens.
- Choose the screen from the file dialog box.
- Use the push buttons to navigate in the list popup.
- When a duplicate record is displayed in the List popup, the push
buttons function incorrectly, hanging in the List popup containing
the duplicate records.