Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strtran() in SQL where clause
Message
From
28/08/2002 09:27:25
 
 
To
28/08/2002 09:18:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00694135
Message ID:
00694409
Views:
11
Hilmar,
SNIP
>
>An index on strtran(...) is virtually useless, since it is of variable length. Any decent VFP index has a fixed length. Perhaps padr(strtran(...)) will achieve better results.

I've heard this many many times, and every time that I read it I wonder to myself...
1) Don't all VFP indexes have a fixed length anyway, INTERNALLY?
2) If VFP lets one create such a TAG, why would it then be useless???

Perhaps you mean that it won't be used by Rushmore?

Jim
>
>Hilmar.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform