PRB: FoxDoc Incorrectly Reports Table Names in DATADICT.DOC

Last reviewed: April 17, 1995
Article 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.

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

  4. 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.

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

  6. Run FoxDoc on the query. In the Main Program/Project Filename box, specify QTEST.QPR.

  7. 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:


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.