>Hi all,
>How to speed up a SQL remote view when calling out from VFP ?
>I have tried to using the fetch mode. It can return the control
>so fast and the program can be opened quickly. But when I issue
>tableupdate(.t.) command, it return an error, it is the connection
>is busy. I know all records of the table is being fetch at the
>background. Thus I can only update the table after the fetch is
>completed. And if I interrupt the fetch process, the table can't
>be updated. When the table is so large, the fetch time is so long.

---

Samuel,
Why do you want to retrieve all of the records from the back-end?
Does the SQL statement of your remote view have a WHERE clause?
If not, I suggest you add one!

Your WHERE clause should also probably be parameterized:
Example: WHERE LastName = ?cLastName
Note the question mark.