Knowledge Base

BUG: Remote View Has Only Two Join Types

Article ID: 157525

Article Last Modified on 10/31/2003

APPLIES TO

Microsoft Visual FoxPro 5.0 Standard Edition
Microsoft Visual FoxPro 5.0a
Microsoft Visual FoxPro 6.0 Professional Edition
Microsoft Data Access Components 2.5

This article was previously published under Q157525

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.

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

STATUS

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

MORE INFORMATION

Steps to Reproduce Behavior

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.
Open a database and create a remote view using the DataSource specified above.
Add a table to the Remote View.
Add another related table to the view. When the Join Condition dialog box appears, click Cancel.
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>."

Additional query words: kbdse VFoxWin

Keywords: kbbug KB157525