Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Coding for rank
Message
From
23/09/2008 03:25:20
 
 
To
23/09/2008 02:54:19
Muthu Vel
Sty Company
India
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01349737
Message ID:
01349740
Views:
19
>I have create a student rank.dbf with five fields namely 1. English 2. Maths 3. Science 4. Total marks 5. Rank.
>
>I want to put the Rank for each student based on their Total marks secured.The total marks is out of 500.
>
>
>For example student A secured total marks is 489 out of 500 and student B is 492 and student C is 389 and student D is 391.
>
>The Rank for Student B is 1 and student A is 2 and student D is 3 and student C is 4.
>
>How to Write source code?

Maybe:
INDEX ON SCORE TAG SCORE DESC
m.i = 1
m.score = SCORE
SCAN
	IF SCORE < m.score
		m.score = SCORE
		i = i+1
	ENDIF
	REPLACE rank WITH i
ENDSCAN
Previous
Reply
Map
View

Click here to load this message in the networking platform