Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-column indexes without conversion to text equivale
Message
From
08/02/2001 15:50:16
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00474159
Message ID:
00474184
Views:
24
>>This strikes me as being inefficient, since the DTOC() and STR() functions would need to be run on the column data, and I am wondering if you can do this another way.
>>
>>Thanks
>
>As Nick noted, you have to convert them all to be string. But I would use DTOS() not DTOC() so that you're dates will be ordered correctly, no matter what the format is.

Thanks, guys.
I was hoping that I had missed something somewhere.

Hey, Fred, thanks for pointing me to another VFP function DTOS(). I had not ever seen that one. What's interesting is that DTOC has an optional number parameter that states it is for maintaining index expressions (the optional [,1]). DTOS() is quicker to type, if nothing else. Now, on to other things:

I understand that I would have to be careful composing scope clauses, etc., in order for RUSHMORE to kick in and use that compound index...
Jim Newsom
IT Director, ICG Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform