Hi Jörg,

How is value property WaitTime of connection?

MartinJ

>Hi Folks!
>
>To show the User response while a big SPT query, I made an Asynchronous SPT Connection. Bud now the Query takes much more Time than before?! Whats wrong?
>
>

>sqlsetprop(lnConnectionHandle,'Asynchronous', .T.) = 1
>	
>store 0 to lnZaehler, lnAnzahl, lnModulo
>lnModulo = 60
>	
>* SQL Komando schicken
>lnOK = sqlExec(lnConnectionHandle, tcSQLStatement, tcCursorname)
>
>do while lnOk = 0			
>   lnOK = sqlExec(lnConnectionHandle)
>   lnZaehler = lnZaehler + 1
>		
>  if mod(lnZaehler,lnModulo)=0
>     lnAnzahl  = 0
>  else
>     lnAnzahl  = lnAnzahl + 1
>  endif
>		
>  set message to "Abfrage wird ausgeführt "+replicate(chr(19),lnAnzahl)
>  inkey(0.5, "H")
>enddo
>
>set message to "Abfrage beendet"
>	
>sqlsetprop(lnConnectionHandle,'Asynchronous', .f.)
>	
>set message to
>
>