>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
lnElapsed = IIF(lnElapsed < 0, lnElapsed + 60*60*24, lnElapsed)
--sb--