Microsoft KB Archive/157525

= 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.



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 "."

Additional query words: kbdse VFoxWin

Keywords: kbbug KB157525

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.