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

 Last reviewed: April 24, 1997
Article ID: Q163787
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a

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. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Issue the following command in the command window: 

          MODIFY DATABASE HOME()+'samples\data\testdata'.

  2. Create a remote view to the testdata!customer table using the Visual FoxPro ODBC driver.

  3. Create a remote view to the testdata!orders table using the Visual FoxPro ODBC driver.

  4. Run the One to Many Form Wizard.

  5. Add the remote view to customer as the parent and select the Cust_id field.

  6. Add the remote view to orders as the child and select all fields.

  7. Select Finish and run the form.

Keywords : buglist3.00 buglist3.00b buglist5.00 FxtoolFormdes kbtool vfoxwin vfpbug5.0a kbbuglist
Version : 5.0a 3.0 3.0b 5.0
Platform : WINDOWS
Issue type : kbbug

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 24, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.