Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Capturing status bar SQL results
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00162975
Message ID:
00162984
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform