Microsoft KB Archive/104466

From BetaArchive Wiki

FIX: Edit Find Not Working in BROWSE After One-to-Many Row

ID: Q104466

2.50    | 2.50

WINDOWS | MS-DOS kbprg kbfixlist kbbuglist The information in this article applies to:

  • Microsoft FoxPro for MS-DOS, version 2.5
  • Microsoft FoxPro for Windows, version 2.5


The Find and Find Again commands on the Edit menu don't work properly in the Browse window of a one-to-many database relationship after they encounter a parent record that has more than one child record.


Microsoft has confirmed this to be a problem in FoxPro 2.5 for MS-DOS and FoxPro 2.5 for Windows. This problem was corrected in FoxPro 2.5a for MS-DOS and FoxPro 2.5a for Windows.


For each record from the parent database that FoxPro displays in the Browse window, all related records (if any) from the child database are displayed. The parent record is displayed once along with the first matching record from the child database. Any subsequent matching records are displayed in the rows following the parent record and the first matching child record. In FoxPro for MS-DOS, shaded blocks are displayed in any columns containing information from the parent database beyond the first matching record. In FoxPro for Windows, the fill character (usually a diamond symbol) for repeated parent information depends on the current Browse window font.

Steps to Reproduce Problem

1. Assuming FoxPro is installed in a directory named FOXPROW on

   drive C, issue the following code:

      SELECT 1
      USE customer.dbf
      SELECT 2
      USE invoices.dbf
      SET ORDER TO TAG cno OF invoices.cdx
      SELECT 1
      SET SKIP TO Invoices
      BROWSE FIELDS, customer.cno, invoices.ino

2. From the Edit menu, choose Find. 3. In the Look For box, type "computer" (without the quotation marks).

4. Under Options, select Ignore Case.

5. Choose OK.

6. From the Edit menu, choose Find Again. Repeat this step until you

   encounter a parent record that has more than one child record.

7. From the Edit menu, choose Find Again. The computer beeps and FoxPro displays the message "Not found."

Additional reference words: FoxDos FoxWin 2.50 buglist2.50 fixlist2.50a 1- to-many children CTRL+G CTRL+F CTRL-G CTRL-F 2.50a 1:many KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxprgBrowse

Keywords          : FxprgBrowse kbbuglist kbfixlist
Version           : 2.50    | 2.50
Platform          : MS-DOS WINDOWS
Solution Type     : kbfix

Last Reviewed: September 24, 1997
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.