Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

BUG: Remote View Has Only Two Join Types


View products that this article applies to.

This article was previously published under Q157525

↑ Back to the top


Symptoms

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

↑ Back to the top


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.

↑ Back to the top


Resolution

The following code sample creates a remote view using a inner join:

Note The user must have appropriate permissions to perform these operations on the database.
      *Start Code Example
      close all
      create data Test1
      MyConnstr="driver=sql server; ";
       + server=MyServernt;uid=UserName;pwd=StrongPassword;database=pubs"
      create connection mycon connstr (MyConnstr)
      create sql view Test1 remote connection mycon Share as select * from;
        titles inner join titleauthor on ;
        titles.title_id=titleauthor.title_id
      *End Code Example
				

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

↑ Back to the top


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 then click the Type drop-down list box.
Note that Only two Join Conditions are available: "Left Outer Join" and "<None>."

↑ Back to the top


Keywords: KB157525, kbbug

↑ Back to the top

Article Info
Article ID : 157525
Revision : 3
Created on : 10/31/2003
Published on : 10/31/2003
Exists online : False
Views : 544