Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Distinct sql command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01237512
Message ID:
01237544
Vues:
18
This message has been marked as the solution to the initial question of the thread.
Try

SET ENGINEBEHAVIOR 80
SELECT GtType DISTINCT FROM VWXLTBL ORDER BY PK INTO CURSOR VWXLTBLID

>if i include the PK field then i do not get the distinct values, just using order by gives me an error.
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform