>SELECT Office.ofc_cde, Office.ofc_name, Office.ofc_seq_num,;
> Ofc_fnctn_link.fnctn_cde, Function.fnctn_desc,;
> Ofc_fnctn_link.ofl_expir_dte, Ofc_fnctn_link.ofl_addr,;
> Ofc_fnctn_link.ofl_city, Ofc_fnctn_link.state_abbr, State.state_name,;
> Ofc_fnctn_link.ctry_abbr;
> FROM ofc_fnctn_link Ofc_fnctn_link, office Office, function Function,;
> {oj state State LEFT OUTER JOIN country Country ;
> ON State.ctry_abbr = Country.ctry_abbr };
> WHERE Office.ofc_seq_num = Ofc_fnctn_link.ofc_seq_num;
> AND Ofc_fnctn_link.fnctn_cde = Function.fnctn_cde;
> AND Ofc_fnctn_link.state_abbr = State.state_abbr;
> AND State.ctry_abbr = Country.ctry_abbr;
> ORDER BY Office.ofc_cde, Office.ofc_name,
> Ofc_fnctn_link.fnctn_cde,;
> Function.fnctn_desc, Ofc_fnctn_link.ofl_city, Ofc_fnctn_link.ctry_abbr
>
>FRONEND: VFP
>BACKEND: VFP.DBC via ODBC
>
> In regards to the SQL statement that VFP produces in the Remote View
> Wizard using the LEFT OUTER JOIN, the above SQL is produced.
> VFP will not let you save this view because of this error.
>
> Connectivity error: [Microsoft][ODBC Visual FoxPro Driver] Comannd
> contrains unrecongnized phrase/keyword.
>
> I think VFP does not recognize the '{' symbol in the SQL.
>
> {oj state State LEFT OUTER JOIN country Country ;
> ON State.ctry_abbr = Country.ctry_abbr };
>
> I know there is a program to let you change an SQL then upload it to a remote view, but this backend will later change to Oracle and it would probably work fine.
>
> Thanks for responding.
possible using Keyword is: 'Function'!!
Try to rename the Function Table first!!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.