>>I usually create a window, set it's top and left to -1000 (so it cannot be seen), activate that window and run the query. That way I never see that message. You can set a variable to the current datetime and subtract that from the time the query finishes.
>
>Now that you mention it, I often use a class for this purpose.
>
>
http://foxridgesystems.com/FoxProVisualFoxProTips/tabid/70/Default.aspx>
>I wonder if I can extend that class to provide the elapsed time and # of records too? Hmmm.
>
>>
>>>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?
Mike,
Out of curiosity checked your tip and found this there:
IF VERSION(5)>=700
If you're checking version then I think you thought the version in use might be older than 7.x? If so version(5) was introduced in VFP6. IMHO a check like this would be more appropriate:
IF type('VERSION(5)')='N' and VERSION(5)>=700
Cetin