Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selected XXXXX records in 2.1 Seconds
Message
From
18/10/2005 18:29:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/10/2005 17:50:27
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060072
Message ID:
01060088
Views:
22
>When I run a select from VFP on the status bar for just a second or two it says:
>
>Selected XXXXXX Records in xx.x seconds
>
>How can I capture and use that value?

The number of selected records is stored to the variable _tally.

You can check the elapsed time with seconds() or with datetime().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform