Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Capturing status bar SQL results
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00162975
Message ID:
00162984
Vues:
14
Try any sql query such as this:
sele dist alltrim(accountno) as x,count(*)as counts from customer group by x order by counts desc
?_vfp.statusbar

Selected 24265 records in 0.78 seconds

However, if I try to set this to a variable I get this number every time.

sele dist alltrim(accountno) as x,count(*)as counts from customer group by x order by counts desc
x = _vfp.statusbar
?x
2252385

*******************************************************************************

My first question would be why do you want to trap this ??? My second question would be why not use the _Tally system variable. It holds the number of records retrieved by the query. If you want to know how long it took to get the records, trap the time before your query started, and then again immediately after. The difference is the ET.

Jason Tryon
Ingram Book Group
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform