Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any way to stop requery process for a local view?
Message
From
16/01/2005 08:42:03
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00976837
Message ID:
00977580
Views:
35
Hi Nadya

>I agree with you, but yesterday we discovered some really nasty indexes like ALLTRIM(UPPER(c_lName)) with FOR conditions.

I see nothing particularly nasty there. UPPER(ALLTRIM()) is supposed to be faster because there are less characters to upper. The FOR conditions automatically suppress Rushmore, but if the code is using seeks for everything, then you'll definitely be breaking stuff.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform