Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odd SQL ORDER BY Behavior
Message
De
03/08/2000 18:06:20
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Odd SQL ORDER BY Behavior
Divers
Thread ID:
00400758
Message ID:
00400758
Vues:
51
Can anyone explain why this does not put the record with "PBMTU" (Pediatric Bone Marrow Transplant Unit) in the last position?

It's for an internal report and really doesn't matter, except that I'm really surprised it comes out in this order.
CREATE CURSOR Dummy (Rec N(1), MyField C(60))
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (1, "CLINICAL ASSOCIATE - Nurse Practitioner")
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (2, "CLINICAL ASSOCIATE - Nurse Practitioner")
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (3, "CLINICAL ASSOCIATE - Nurse Practitioner")
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (4, "CLINICAL ASSOCIATE - Nurse Practitioner")
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (5, "CLINICAL ASSOCIATE - Nurse Practitioner")
INSERT INTO Dummy (Rec, MyField) VALUES ;
    (6, "CLINICAL ASSOCIATE - Nurse Practitioner")

SELECT Rec, ;
    PADR(ALLT(MyField) + IIF(Rec = 3, " - PBMTU", ""), 50) ;
    AS MyField ;
    FROM Dummy ;
    ORDER BY 1, 2
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform