PRB: Remote View Has Only Two Join Types

 Last reviewed: October 29, 1996
Article ID: Q157525
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, version 5.0

SYMPTOMS

The Remote View designer has only two types of Join conditions, Left Outer and None.

CAUSE

Visual FoxPro delegates the SQL query to the ODBC driver in order to be compatible across multiple back ends. Visual FoxPro uses the ODBC outer join extension, which supports only left outer join.

WORKAROUND

Users could implement right outer join by reversing the table order. There is no support for full outer join.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Using the 32-Bit ODBC Driver Manager, create a DataSource for a database on a Remote Server like the "pubs" database on Microsoft SQL Server.

  2. Open a database and create a remote view using the DataSource specified above.

  3. Add a table to the Remote View.

  4. Add another related table to the view. When the Join Condition dialog box appears, click Cancel.

  5. Click the Join tab of the Remote View designer and click the Type drop-
down list box.

Only two Join Conditions are available: "Left Outer Join" and "<None>."

KBCategory: kbtool kbprb
KBSubcategory: FxtoolQueryvwdes
Additional reference words: 5.00 kbdse VFoxWin



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: October 29, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.