General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Rich,
My experience with remote views is with a Fox database on the backend. I do not know if the following comments apply to SQL Server, Oracle, etc...
A remote views work very well for updating, inserting and deleting data. They are extremely slow, however, for record selection. This is because VFP pulls the entire dataset before applying any filters. For this I use SQL Passthrough to query the data, and the database only sends the filtered dataset.
I do not believe that you can call a stored procedure in a remote VFP database.
Phil
Previous
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