General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Remote Views in VFP 6.0 SP5
In the view designer, I don't seem to be able to use the 'left join' to access either VFP data or MS SQL. I get error message ('Connectivity Error, MS Visual FoxPro an ODBC error Syntax Error' and when I take a look at the generated SQL through 'view SQL' in the view designer, it has some rubbish characters.
Now I can programmatically create that remote views by using 'Create SQL View' command.
Any Idea how to get over that problem? I am using VFP 6.0 SP5 on a client maching running Windows 98 with MDAC 2.8.
Thanks in advance.
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