ActiveVFP Backend and VFP Client (Asynchronous Retrieval)

Topics: Developer Forum, Project Management Forum, User Forum
Jun 5, 2012 at 8:10 AM

I want my VFP application to send SQL SELECT statement to ActiveVFP. ActiveVFP then executes the SELECT statement and sends the results to my VFP application in an asynchronous manner. Do you have sample for this scenario? The asynchronous way of retrieving the data is very important because the SELECT statement could yield thousands or even millions of records.

Jun 5, 2012 at 5:01 PM
Edited Jun 5, 2012 at 5:13 PM

It's gonna come back from AVFP just like any other web page over HTTP.    You could try Christian Ehlscheid's CreateThreadObject in VFP2C32.fll (in VFPx) in your desktop app to have multiple threads pulling the records down from AVFP.  The VFPWebCrawler project at codeplex  is an example using Calvin Hsia's multi-threading class that does something similar.

Actually, you want records and not screen scraping, so something like this Offline Reader could easily be done in AVFP.