Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ORDER of Cursor
Message
De
10/04/2008 21:24:18
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ORDER of Cursor
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01309859
Message ID:
01309859
Vues:
53
This is a section of SQL. I need the results in the order below. I am unable to have any additional fields in the result cursor than what is already in the SQL. I've been unable to do anything with the ORDER clause that didn't return an error. How can I do this?

Desired Order:

P = 1
S = 2
T = 3
A = 4
W = 5


PADR(THIS.Strip(TRANSFORM(;
IIF(Covr.CvPS='P','Primary',;
IIF(Covr.CvPS='S','Secondary',;
IIF(Covr.CvPS='T','Tertiary',;
IIF(Covr.CvPS='A','Auto',;
IIF(Covr.CvPS='W','Workmans Compensation','Other))))), '@T')), 30, ' ') ;
AS IN1_22_00_Coord_of_Benefit_Priority

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform