Microsoft KB Archive/221652

= 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 =

Article ID: 221652

Article Last Modified on 2/8/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



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



Steps to Reproduce Behavior
 Create a report. Add the Customer table to the data environment. Add the Cust_id, City, and Country fields to the report. Save the report with the name Ztest.  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. 

Keywords: kbbug kbfix kbreportwriter kbvs600sp3fix KB221652

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.