No, AFAIK, but you can use SECONDS() function to calculate it. This way you can measure duration of any process, not just SQL Select
lnStart = SECONDS()
SELECT ....
lnTotalTime = SECONDS() - lnStart
Just remember that SECONDS() returns number of seconds since midnight. Add 86400 if your process croses midnight. lnTotalTime will be negative number in this case.
>When you do a select in VFP if Set talk is on and Set status bar is on you will get the amount of time to do the select SQL.
>
>Is there a system variable that will give me the time spend for the select SQL?
>
>>>I have a pc with 512mb of ram. When I do big process with vfp I get a big amount of memmory use be vfp.
>>>
>>>How can I limite the amount of memory use by VFP?
>>>What is the best size of memory to use with VFP?
>>
>>Take a look at faq#8125.
--sb--