>>>>>>>>So, how can I get the SQL Server session id my query is running in?
>>>>>>>
>>>>>>>SELECT @@SPID
>>>>>>
>>>>>>Thank you.
>>>>>>
>>>>>>So, you say the query that runs the lengthy query should have an asynchronous connection, and the one that reads the advance of the first query should not be asynchronous. What I don get is, in what moment the one that reads the advance should be issued? And how can I know that the lengthy query is completed?
>>>>>
>>>>>Yes,.... and you can run the query that read the advance whenever (e.g. timer) you want to update the user on its progress
>>>>>
>>>>>You know when the query is completed when SQLEXEC(nASyncHandle) returns any other values than 0
>>>>>
>>>>>Walter,
>>>>
>>>>So, I guess I should do something like this:
>>>>

>>>>lnConn= SQLCONNECT('myOdbcDsn', 'myUserId', 'myPassword')
>>>>SQLSETPROP(lnConn, 'Asynchronous', .T.)
>>>>DO WHILE SQLEXEC(lnConn, 'SELECT * FROM myOrders', 'myCursor') = 0
>>>>   ** Show user something...
>>>>   ** Update progressbar...
>>>>ENDDO
>>>>** Continue program flow.
>>>>

>>>>
>>>>If my example is correct, how can I know whether the long query terminated fine (returned 1) or not (returned -1) after the DO...WHILE loop?.
>>>>
>>>>TIA.
>>>
>>>Yes, that would be ok. I'd build some delay (like a Sleep API call) of 100 ms in there.
>>
>>Thanks Walter. But what is still not clear to me, is when to use SQLEXEC(lnConn), in other wrods, when / where to use SQLEXEC () without the "SELECT" command.
>>
>
>Ok, the following is untested, but I guess the following would work
>
>

>nhandle1 = SQLSTRINGCONNECT(cConnectionString)
>nhandle2 = SQLSTRINGCONNECT(cConnectionString)
>
>SQLSETPROP(nHandle1,"Asynchronous", .T.)
>
>** Get the SPID you need for determining the progress
>SQLEXEC(nHandle2, "SELECT @@SPID as spid","X")
>nSPID = X.SPID
>
>** Execute the main query, asynchronously
>SQLEXEC(nHandle1, "SELECT * FROM Orders", "Orders")
>
>** Wait for it to complete
>DO WHILE SQLEXEC(nHandle1) = 0
>
>	** Query still runs, get the progress
>	SQLEXEC(nHandle2, "SELECT percent_complete FROM sys.dm_exec_requests WHERE session_id=?nSPID", "Y")
>	nPercent = y.percent_complete
>
>	**Update progress bar
>	DO updateProgressbar WITH nPercent
>	
>	** Sleep 100 ms
>	Sleep(100)
>ENDDO
>
>SELECT Orders
>....
>

>
>Walter,

Now it's vrey clear. Thank you Walter.