General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to use MS SQL from Foxpro
How do I use an SQL table from Foxpro???
I am able to connect and setup a View, but I have to build a select statement that narrows down to one (or a few) records in the SQL table. If I just try to "open" the SQL table, it will download *ALL* of the table and can take MANY MANY minutes. SO my view just gets the ONE record I want, but to go to another record, I must close the view, change the select statement memory variables and open the table again. It is literally 100 times faster to use Foxpro on a copy of the SQL table, but I need to use teh real SQL data.
HOW DO I OPEN A SQL TABLE????
I do appreciate your help!!!!!
Joel
Houston, TX
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