Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT Statement
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00513062
Message ID:
00513214
Vues:
16
This message has been marked as a message which has helped to the initial question of the thread.
>>because the last names may not be in order. i'm not using an index at this point to select against. and if the user wants names that being with T, then they will come up in the order of Teamster, Thankson, Thompson, Tikiwater, etc etc....
>
>Use order by clause instead of group by. You may have two or more Thompston in your database, but with Group by you will have only one record for all of them.

BTW, you can use index on command once on cursors without re-openning it in read-write mode.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform