Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selected XXXXX records in 2.1 Seconds
Message
From
20/10/2005 13:01:56
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
20/10/2005 12:23:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
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:
01060781
Views:
13
>>>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!
Previous
Reply
Map
View

Click here to load this message in the networking platform