Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why I don't see the SQL thermometer the second time?
Message
De
23/12/2005 13:18:06
Mike Yearwood
Toronto, Ontario, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01080422
Message ID:
01080598
Vues:
19
This message has been marked as the solution to the initial question of the thread.
>>>Long enough for thermometer to appear, I believe.
>>>Do you want me to add time stats to measure?
>>
>>My guess would be that during the first run VFP caches data wich causes subsequent queries to run faster.
>
>Right, but still it is not fast enough. In other words, I'm looking on the screen and nothing happens for ~20 seconds.

VFP won't show the progress bar unless it determines it's needed.

BTW, wouldn't you prefer to type this...
m.loThermo = NewObject("cusSQLThermo","cusSQLThermo.VCX")
			lnAccounts = m.poProcess.GetAccounts(m.lcQueue_Name_From, ;
				m.goApp.cDept, m.lcWhere, ;
				.cAdditionalJoin, m.ldStartDate, m.lnUsers * .txtAccountsPerUser.value)
RELEASE m.loThermo
INSTEAD of all of this?
lcNotify = set('notify')
			set notify on
			set talk on
			set talk window
			lnAccounts = m.poProcess.GetAccounts(m.lcQueue_Name_From, ;
				m.goApp.cDept, m.lcWhere, ;
				.cAdditionalJoin, m.ldStartDate, m.lnUsers * .txtAccountsPerUser.value)

			if m.lcNotify = 'OFF'
				set notify off
			endif
			set talk off
If so, try this class...

http://foxridgesoftware.com/Blogs/tabid/84/EntryID/2/Default.aspx
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform