Microsoft KB Archive/104466
FIX: Edit Find Not Working in BROWSE After One-to-Many Row
2.50 | 2.50
WINDOWS | MS-DOS kbprg kbfixlist kbbuglist The information in this article applies to:
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: 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