Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow Asynchronous SPT
Message
From
10/11/2004 07:06:23
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00959904
Message ID:
00959920
Views:
7
>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
>>
>>
wait time = default = 100 milliseconds
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform