>You can probably use an Asynchronous connection. That way, SQLExec will come back inmediatly and your browse will show up quickly.
>HOWEVER (big HOWEVER <g>) working with asynchrounous connections is not as easy as it sounds. With an asynchronous you will need to be looping (probably in a timer) asking VFP if it has finished downloading records while the user is still browsing records.
>Also, I have found scenarios where VFP does not work asynchronous (and thus the user needs to wait) even when the connection is asynchronous.
>Anyway, you can problably play with it and see if it does what you need.
Yes, I've tried setting
SqlSetProp (nSQLHandle, "Asynchronous", .T.) and implement a cursor "fill" loop before, but couldn't make it work properly. What I'm needing is the
exact statement sequence to do it. In all books I have and in the MF VFP 6.0 manuals I couldn't find an answer to my problem.
Thanks,
Fernando