Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selected XXXXX records in 2.1 Seconds
Message
 
 
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:
01060089
Views:
17
>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 _TALLY will hold the number of records selected (XXXXXX ). The time elapsed isn't avalable but you can get it with a few additional lines of code.
lnSeconds = SECONDS()
SELECT * FROM mytable ....
lnElapsed = SECONDS() - lnSeconds
* Account for midnight reset.
lnElapsed = IIF(lnElapsed < 0, lnElapsed + 60*60*24, lnElapsed) 
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform