>>>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
Thanks Cetin. I'll adjust it soon!