Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameters for Order by in SQL?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00131023
Message ID:
00131067
Vues:
40
>Ed -
>
>Thanks a lot - this worked (I also found I can use something like "6,5" in N to order by two or more fields). I see you used macro substitution as opposed to the parameterized notation (?somefield) the article indicated could be used. Given that, is there any advantage to using the field number in this kind of situation instead of the field name (or doesn't it make a difference)?
>
>Sylvia

Hi Sylvia,

Just my .02 (US) here. I'd opt for names. I think it's more flexible. Using the field number ties query to the order of the field within the table. If the structure changes, say a new field is inserted, then this would have to change too. Using the name doesn't have this problem.
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform