PRB: Creating Join in Join Condition Dialog Box Creates Filter (192860)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q192860

SYMPTOMS

When creating a remote view though the View Designer, if a join condition is specified in the Join Condition Dialog box, the join condition is specified as a filter rather than a join.

RESOLUTION

If you desire to use the Join syntax, you should use the Join tab to specify your join condition. You can also use the CREATE SQL VIEW command to create the remote view.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a remote view though the View Designer.
  2. Add two related tables, and note that the Join Condition dialog box is displayed.
  3. Create a join in that dialog and close the dialog.
  4. Click the Join tab in the View Designer, and note that there is no join specified there.
  5. Click the Filter tab in the View Designer. Note that there is a filter entered that matches the join condition specified in the Join Condition dialog box.
Modification Type:MajorLast Reviewed:12/11/1999
Keywords:kbprb KB192860
©2002 Microsoft Corporation. All rights reserved.