BUG: dBASE Report with Similar Name Overwrites FoxPro Report

ID: Q114196

The information in this article applies to:

SYMPTOMS

If you have two reports in Catalog Manager, one created in dBASE and another created in FoxPro, that have similar filenames (the first eight characters are identical), the dBASE-style report overwrites the FoxPro- style report when it is transported the first time it is printed or modified.

After the dBASE-style report is transported, both entries will use the same .FRX file.

STATUS

Microsoft has confirmed this to be a problem in FoxPro version 2.6 for Windows and FoxPro version 2.6 for MS-DOS. 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

This example uses the SAMPLES catalog file provided with dBASE.

 1. If the Catalog Manager is not displayed, choose Catalog Manager
    from the File menu.

 2. Open the SAMPLES catalog file.

 3. Choose the Report tab area. Select INVENTRY. Note that the Data
    Source is CONTENTS.DBF.

 4. Choose New. From the Select A Table Or Query popup, select
    NAMES.DBF. Choose the Report Wizard button.

 5. Select Report Wizard, and then choose Next.

 6. Choose Next when prompted to select a style.

 7. Move the LASTNAME and FIRSTNAME fields from the Available Fields
    list box to the Selected Fields list box. Choose Finish.

 8. When prompted to enter a title for the report, choose Finish.

 9. Save the report as INVENTRY.FRX.

10. FoxPro returns you to Catalog Manager. Select the original
    INVENTRY report (the report that lists CONTENTS.DBF as its
    source).

11. Choose Modify. You are prompted with the following message:

       File INVENTRY.FRX already exists. Overwrite it?

    Choose Yes.

12. When the report is finished transporting, close the Report Layout
    window.

After returning to Catalog Manager, note that there are still two entries for INVENTRY, each listing a different data source. However, choosing modify for either report modifies the INVENTRY.FRX file, which is based on CONTENTS.DBF.

Additional reference words: FoxDos FoxWin 2.60 buglist2.60 replace KBCategory: kbother kbbuglist KBSubcategory: FxtoolWizother

Last Reviewed: June 27, 1995