General information
Title:
VFP as Backend LEFT OUTER JOIN problem.
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only