Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT TOP ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00396652
Message ID:
00396765
Vues:
11
>Thanks for the post. Unfortunately, it doesn't quite work. If I use it to retrieve TOP 3 and the first two are blank and the next two have values, I'll get one blank and the two with values. I would want the two blanks at the top and the next row with a value.
>
>Mike


Mike,

I guess that you have unique key field for each record in b_pods table (say cId).
Add it to Order By clause and you should get only 1 record

SELECT TOP 1 * FROM B_PODS INTO CURSOR csrRETURN ORDER BY DESCRIP, cId
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform