Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collate - Index on Deleted() Tag DeletedTag Binary
Message
 
À
26/08/2005 14:11:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01044347
Message ID:
01044425
Vues:
19
Fabio,

I think my problem does not have solution. BINARY INDEXES just work fine if you have all indexes in MACHINE collate.

My problem is... The user wants to find someone that has the first name like "Jo" (it means Jose, José, João, João, Joana, etc)... So, I have to list it for him in the right order (GENERAL collate)

If I add this new index, and use it in a network, the query runs too slow.
If I try to change the binary index from machine to general, I get an error message.
If I change my indexes to machine, my results is a little bit confused.

So, I think I will not use DELETED() index. I want to improve a little bit, but I think it is not possible.

By the way: When I have to list all names that start with "Jo", I use it:

Select * From MyTable Where Name Likes "Jo%" Into Cursor Resultado
<\pre>
and I think it works fine, I mean, rushmore!

Thanks!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform