Microsoft KB Archive/244928

= PRB: Unrecognized Phrase/Keyword Message when Attempting to Save a Remote View Using a Join Clause =

Article ID: 244928

Article Last Modified on 2/23/2000

-

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 Q244928



SYMPTOMS
When attempting to save a remote view, an error message similar to the following appears:

Connectivity Error: [Microsoft][ODBC Visual FoxPro Driver] Command contains unrecognized phrase/keyword



RESOLUTION
Create remote views that include a JOIN clause programmatically.



Steps to Reproduce Behavior
  Create a program file named Remoview.prg, using the following code: CREATE DATA testa CREATE TABLE tablea (fld1 c(10), fld2 c(10)) CREATE TABLE tableb (fld1 c(10), fld3 c(10))

CLOSE ALL

CREATE DATA testb CREATE CONNECTION connect1 CONNSTRING 'DRIVER={Microsoft Visual FoxPro Driver};' + ; 'Exclusive=No;SourceType=DBC;SourceDB='+SYS(5)+SYS(2003)+'\TESTA.DBC'

CREATE SQL VIEW innersql REMOTE CONNECTION connect1 ; AS SELECT * ; FROM testa!tablea tablea JOIN testa!tableb tableb ; ON tableb.fld1 = tablea.fld1

CREATE SQL VIEW leftsql REMOTE CONNECTION connect1 ; AS SELECT * ; FROM testa!tablea tablea LEFT JOIN testa!tableb tableb ; ON tableb.fld1 = tablea.fld1

CREATE SQL VIEW rightsql REMOTE CONNECTION connect1 ; AS SELECT * ; FROM testa!tablea tablea RIGHT JOIN testa!tableb tableb ; ON tablea.fld1 = tableb.fld1

MODI VIEW innersql MODI VIEW leftsql MODI VIEW rightsql  Save and run the program file. When the View Designer opens for the "innersql" remote view, press the CTRL+W keys and note the error message that appears. When the View Designer opens for the "leftsql" remote view, click File, then click Save from the main Visual FoxPro menu and note the error message that appears. When the View Designer opens for the "rightsql" remote view, click File, then click Save As from the main Visual FoxPro menu and note the error message that appears after entering a view name and pressing OK.

Keywords: kbcodesnippet kbdatabase kbdesigner kbprb kbpending KB244928

-

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

© Microsoft Corporation. All rights reserved.