Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL to get the alphabetical next
Message
 
 
À
25/04/2003 09:31:32
Km Kwun
Eastop Consultants Limited
Nt, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00771820
Message ID:
00781474
Vues:
16
You're welcome.

>Sergey,
>
>Thanks a lot for your further advice.
>
>KM
>
>
>>I think you should change ORDER BY clause to
ORDER BY lastname, firstname, CustID
otherwise you could miss some records under following conditions
>>- First and last name are the same
>>- There are more than 2 such records
>>- CustID values arent in sequential order in those records.
>>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform