Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Implementing a Browse with SQL Pass Thru
Message
From
04/02/2002 11:33:22
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00614848
Message ID:
00614862
Views:
31
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform