Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incompatibility with VFP 9
Message
De
14/01/2005 11:52:49
 
 
À
14/01/2005 11:44:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00977235
Message ID:
00977238
Vues:
19
Michel

Shouldn't "order by" be the last clause of the SQL, after the "into", or doesn't it matter?

Terry

>The following doesn't work anymore in VFP 9:
>
>
>SELECT *,Numero AS OrderMain FROM Message INTO CURSOR Temp READWRITE
>INDEX ON STR(Numero)+STR(Ordermain) TAG OrderMain
>SELECT DISTINCT Numero FROM Temp ORDER BY OrderMain INTO CURSOR Temp2
>
>
>It says SQL: ORDER BY clause is invalid
>
>I am trying to localize the problem and I also need to find a workaround. If someone has an answer right away, that would be appreciated.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform