Hi!

See FAQ#8150. Progressive fetching (in form of progress displaying for downloading) is noe there too.

I also want to thanks you, Fernando for giving the right direction and pointing me to the fact that VFP HAS this feature for SPT (before I beleived that it has no such feature). Now I will go through my older messages on several sites and forums and send note about this. You're not the first who asking about such things.


>James,
>
>I implemented the desired Browse functionality, using the statements sequence Vlad told me to (see in this thread - message #615397). Actually it is implemented in a "fetchasneeded" way. I wanted to simulate a VFP DBF Browse and it does that just by fetching more records when user wants it, moving the "record pointer" beyond the browse window bottom.
>
>There is another sequence, in the same program (it is a small utility to be used by developers, not end users!), to perform SQL Selects entered in an edit window by the user, that provides them with the ability to pause it and then cancel it or continue:
>

>SqlPrepare (gSQLHandle, gObjtSQLcommand, "SQLcurSelect")
>. . .
>CursorSetProp ("FetchSize", 100          ,  0 )
>SQLSetProp    (gSQLHandle, "Asynchronous", .T.)
>
>Do While SQLExec (gSQLHandle) = 0
>
>   If InKey (.001) = 27
>      If MessageBox ("Do you want to stop the executing Select ?", (4+48+256), cCaption) = 7
>         Loop
>      endif
>      SqlCancel (gSQLHandle)
>      Exit
>   endif
>
>EndDo
>
>CursorSetProp ("FetchSize", 300          ,  0 )
>SQLSetProp    (gSQLHandle, "Asynchronous", .F.)
>

>The Inkey (.001) idea is not the best solution, but I'm still developing the whole thing, and latter I'll provide a better shape to it. I'm still learning how to tame this (SPT) beast!
>
>Fernando