Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the best index expression?
Message
 
 
To
19/04/2005 12:23:23
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:
01005870
Message ID:
01006257
Views:
17
>Hi Nadya,
>
>I only skimmed this thread, but
>
>CASE m.lnTriggerType = TriggerTypeCode
>   m.lcSearch = PADR(m.lcSearch, FSIZE("searchTB"))
>   SCAN WHILE !m.plError AND SearchTB == m.lcSearch FOR NOT EMPTY(CommandField)
>      ...
>   ENDSCAN
>...
>
I'ld be hesitant to use this since "while" in scan implies Scope REST (where is the go top ?) and I'ld guess it would also eliminate rushmore (the docs are a bit ambiguos from AFAIR). I tend to use "while" only in seek() scan-scenarios. In the code above Rushmore is certainly disabled for SearchTB == m.lcSearch and I don't see a if seek() ?
>
>regards
>
>thomas

In my code I just use SCAN FOR with only one index on SearchTB. I'll send you my latest code by e-mail.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform