Microsoft KB Archive/163787

= FIX: Form Wizard Doesn't Limit Grid Contents to Related Record =

Article ID: 163787

Article Last Modified on 2/24/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 Data Access Components 2.5

-



This article was previously published under Q163787



SYMPTOMS
If you use the One to Many Form Wizard from a remote view, the grid created by the Wizard does not limit the contents to the related records.



RESOLUTION
To work around the problem, add the following line of code, as indicated, to the txtbtns.NavRefresh method in the Visual FoxPro \WIZARDS\WIZSTYLE.VCX: CASE THIS.ViewType = 1       &&local views SET FILTER TO &cFiltExpr CASE THIS.ViewType = 2       &&remote views SET FILTER TO &cFiltExpr  && Add this line to the method ENDCASE



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This has been corrected in Visual FoxPro 6.0.



Steps to Reproduce Behavior
  Issue the following command in the command window: MODIFY DATABASE HOME+'samples\data\testdata'.  Create a remote view to the testdata!customer table using the Visual FoxPro ODBC driver. Create a remote view to the testdata!orders table using the Visual FoxPro ODBC driver. Run the One to Many Form Wizard. Add the remote view to customer as the parent and select the Cust_id field. Add the remote view to orders as the child and select all fields.</li> Select Finish and run the form.</li></ol>

Additional query words: kbvfp600fix

Keywords: kbbug kbfix KB163787

-

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

© Microsoft Corporation. All rights reserved.