Hi!

I finally found it!!!

See below in the code:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
nn = SQLStringConnect("Driver=SQL Server;Server=SCORPIO;Database=XXXXX;UID=XXXXX;PWD=XXXXXX;")

CursorSetProp("FetchAsNeeded",.T.,0)
CursorSetProp("FetchSize",300,0)
SQLSetProp(nn,"Asynchronous",.T.)

do while NOT USED("MyResult") && SQLEXEC() will return 0 till all records returned.
&& When you want to fetch, just wait till alias created with
&& first FetchSize number of records (300 in this sample)
=SQLExec(nn,"SELECT * FROM TEST","MyResult")
enddo

browse last
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

As you see, you can define default values for cursor properties, using "0" as a reference to cursor alais. New cursors opened will automatically get these values by default.

So, now it is possible to display progress bar for SPT...

I guess this should go into the FAQ article. Will do this today.

HTH.

>Vlad, I thank you very much for your help and efforts!
>
>If the fine manual says it can be done, we'll find the way to do it, I'm sure! If there is a bug in SPT, perhaps somebody else can tell us about it, and how to handle it.
>
>I just wonder why it is so cumbersome to acomplish such a task with SPT. Using SPT for other ones is very straightforward. I don't believe views are the solution for every need, but...
>
>Fernando