Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore and collate
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00202772
Message ID:
00204914
Views:
19
>
>P.S.: After all, who dare to use collate sequences other than machine?

Bela,

I still dare! Let me explain you how. First, on my tables, everything is now MACHINE, no question about it! But I am working mostly with views. So, when the user has entered one or more search parameters, I present him the resulting data set in grid format. I index my views, and when needed use the GENERAL collating sequence. Since this is only a subset of data, the time penalty is not important. And I don't use these indexes for anything else, so no error either.

José
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform