PRB: FoxDoc Incorrectly Reports Table Names in DATADICT.DOC

ID: Q103030

The information in this article applies to:

Microsoft FoxPro for MS-DOS, version 2.5a

SYMPTOMS

When FoxDoc is run on a project that contains a query that builds a quick report, the FoxDoc-generated DATADICT.DOC is inaccurate.

CAUSE

FoxDoc incorrectly parses the .QPR file, interpreting each keyword in the REPORT FORM command as a table.

RESOLUTION

Do not use the Query Builder Quick Report option. Manually design a quick report using the Report Writer. Create a .PRG file that includes a call to the .QPR file and a call to the REPORT FORM command.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a new query QTEST.QPR file.

2. Base the query upon CUSTOMER.DBF in the FOXPRO25A\TUTORIAL

   subdirectory.

4. Redirect the output of the query to Report/Label.

5. Select Options. In the RQBE Display Options dialog box, select

   Report, and then select Quick Report. Accept the default name
   (QUERY.FRX) or specify another.

6. Save the query, and return to the Command window.

7. Run FoxDoc on the query. In the Main Program/Project Filename box,

   specify QTEST.QPR.

8. Issue the following command:

      MODIFY FILE datadict.doc

   If you have used the defaults, the document should summarize use of
   the following databases:

      CUSTOME.DBF
      CREATE.DBF
      REPORT.DBF
      QUERY.FRX
      FROM.DBF
      QUERY.DBF
      WIDTH.DBF
      80.DBF
      COLUMN.DBF
      NOOVERWRITE.DBF

FoxDoc seems to be interpreting several keywords in the CREATE REPORT and REPORT FORM command line as individual tables. Additionally, FoxDoc truncates the actual table name upon which the query is built. The FoxDoc-documented QTEST.QPR file is similarly inaccurate.

This behavior also occurs if the query is added to a project. It does not occur if the Quick Report option is not selected.

Additional reference words: FoxDos 2.50a KBCategory: kbprg kbprb KBSubcategory: