FIX: The filter is ignored if you use the NOWAIT clause with a filter when you preview a report that has a table in the data environment in Visual FoxPro for Windows (221652)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b
  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 5.0a
  • Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q221652

SYMPTOMS

When a report has a table in the data environment and you use the NOWAIT clause with a filter, the first record of the table appears, ignoring the filter. This behavior only happens with the PREVIEW clause. Printing a report to the printer with the NOWAIT clause works as expected.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3.

For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a report.
  2. Add the Customer table to the data environment.
  3. Add the Cust_id, City, and Country fields to the report.
  4. Save the report with the name Ztest.
  5. Issue the following command in the Command window:
    REPORT FORM Ztest FOR Country = "USA" PREVIEW NOWAIT
    Notice that the first record in the report is from the country Germany and not the United States.
Modification Type:MajorLast Reviewed:2/8/2005
Keywords:kbBug kbfix kbReportWriter kbVS600sp3fix KB221652
©2004 Microsoft Corporation. All rights reserved.