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.