Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using expression in ORDER BY clause
Message
De
18/10/2001 13:05:51
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Using expression in ORDER BY clause
Divers
Thread ID:
00570371
Message ID:
00570371
Vues:
50
From VFP 7 help:

Each Order_Item must correspond to a column in the query results and can be one of the following:
...
A numeric expression indicating the location of the column in the result table.

However, the following program causes error

SQL: Column 'NORDER' is not found.

How to use expressions in ORDER BY clause ?
norder = 1
CREATE CURSOR test ( test c(1) )
SELECT * from test ORDER BY (norder)
Andrus
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform