Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ORDER of Cursor
Message
From
10/04/2008 21:24:18
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ORDER of Cursor
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01309859
Message ID:
01309859
Views:
52
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

Next
Reply
Map
View

Click here to load this message in the networking platform