>Hi Borislav
>
>>>I have 2 SQL SELECT statements, executed one by one. The problem arise when I wanted to use the returned cursor of the first SPT in the second. The backend is SQL server.
>>>
>>>How can I acheive this? Please advise.
>>
>>How to use it?
>>To update something or you want to use it to filtering data?
>
>It is more like further JOINing. I mean the first SPT uses a few backend tables and creates a cursor in VFP. The second one again does a SPT, but this time the just created cursor is JOINed with another backend table to create a second cursor to be used seperately.
>
>Hope this is what you wanted to know.

You can't do that.
SPT cursor (or any other VFP Table/Cursor) is not visible to SQL Server, you can't pass it as Parameter. You could save it to a table and join it with using T-SQL OPENROWSET() function, but this is slooooow :o)
You could do this joing two ways:
1. Use derived table with exact the same SELECT as first SPT cursor:

TEXT TO lcFirstCursorSelect NOSHOW TEXTMERGE
     SELECT ....
            FROM .....
            WHERE ....
ENDTEXT

TEXT TO lcSecondCursorSelect NOSHOW TEXTMERGE
     SELECT ....
            FROM .....
     JOIN (<<lcFirstCursorSelect>>) TblFrst ON .......
     WHERE ....
ENDTEXT

2. Select records w/o joining and than select jojned records using both SPT cursors in VFP.
I personaly prefer first suggestion, because it is faster and you get all records you need directly.