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

SYMPTOMS

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.

STATUS

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.

MORE INFORMATION

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:

      SET DEFAULT TO C:\FOXPROW\TUTORIAL
      SELECT 1
      USE customer.dbf
      SELECT 2
      USE invoices.dbf
      SET ORDER TO TAG cno OF invoices.cdx
      SELECT 1
      SET RELATION TO cno INTO Invoices ADDITIVE
      SET SKIP TO Invoices
      BROWSE FIELDS customer.company, 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