>>Hello,
>>
>>I have complex query which runs more than 30 seconds on SQL server.
>>When I'm processing this query from VFP, program stops responding until results were returned.
>>I saw that it's possible to use SQLEXEC asynchronously, but didn't find good article how to use it.
>>Can anybody send me a link to resource where it is possible to read about using SQLEXEC asynchronously with examples.
>>
>>Thanks in advance.
>
>On top of my head
>

>*** Set the query to be ran asynchronously
>SQLSETPROP(sqlHandler, [Asynchronous], .t.)
>IF SQLEXEC(sqlHandler,....,[crsCursorThatReceiveResultSet]) < 0 && Your long query
>   AERROR(laError)
>   MessageBox([Query can not be ran ]+laError[1,2])
>   SQLSETPROP(sqlHandler, [Asynchronous], .f.)
>   RETURN
>ENDIF
>
>....
>&& There where you first time need the result of that query:
>IF NOT USED([crsCursorThatReceiveResultSet]) && Query still runs
>   *** Do something
>   RETURN
>ENDIF
>SELECT crsCursorThatReceiveResultSet
>GO BOTTOM && Force whole resultset to be received.
>....
>

>Don't forget to reset back [Asynchronous] for this sqlHandler.

Thanks!!!