Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incompatibility with VFP 9
Message
De
14/01/2005 11:55:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00977235
Message ID:
00977241
Vues:
27
>It's documented change in the SQL Engine behavior: ORDER BY clause cannot include field that it's not in the field list if DISTINCT is used. You can add OrderMain to the field list.
SELECT DISTINCT Numero, OrderMain FROM Temp ORDER BY OrderMain INTO CURSOR Temp2
By doing this, I have no bug. But, the SQL result is double and that fakes the result I need to achieve.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform