Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order By?
Message
De
23/12/1999 10:35:28
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Order By?
Divers
Thread ID:
00307929
Message ID:
00307929
Vues:
57
When run, an error comes up that says the order by statement is invalid. what is wrong?

select data1.bundle+data2.bundles+data3.bundle+data4.bundles+data5.bundle+data6.bundle+data7.bundle+data8.bundle;
as acBundle2;
from data1, data2,data3,data4,data5,data6,data7,data8 ;
where data1.grade + data1.siz + data1.length = data2.grade + data2.siz + data2.length;
and data2.grade + data2.siz + data2.length = data3.grade + data3.siz + data3.length;
and data3.grade + data3.siz + data4.length = data4.grade + data4.siz + data4.length;
and data4.grade + data4.siz + data4.length = data5.grade + data5.siz + data5.length;
and data5.grade + data5.siz + data5.length = data6.grade + data6.siz + data6.length;
and data6.grade + data6.siz + data6.length = data7.grade + data7.siz + data7.length;
and data7.grade + data7.siz + data7.length = data8.grade + data8.siz + data8.length;
and data1.grade = gdValue and data1.siz = szValue and data1.length = 2 ;
order by 2 ;
into cursor myCursor


Merry Christmas,
JD
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform