'Select Visual FoxPro Search a dbf meanwhile is connected to an sql database
In a simple program where i connect from visual foxpro to a sql server with the connectionstring and i have already controlled if is connected successfully when i create a simple select command with the name of the table from the database the program try to search the table in local and expect me to give him a dbf file meanwhile the table is in the database in sql
Select * FROM table Where column=k into cursor nnn
Solution 1:[1]
You have added a connection string to a VFP database. This does not mean that you can then just query any table on the SQL server in a regular SELECT statement. Instead you create a remote view with your query and then open the remote view like a table.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Christof Wollenhaupt |