Sorting in FoxPro with Example
Sorting in FoxPro with Example
Sorting in FoxPro with Example
ARRANGING RECORD USING SORT
SORT – Open Database File के Records को Ascending या Descending Order में Arrange करके एक New File में संगृहीत करता है
Ex – Use Student
List
Rec# |
NAME |
AGE |
COURSE |
FEES |
1 |
RAJESH |
21 |
DCA |
5000 |
2 |
AJAY |
25 |
PGDCA |
8000 |
3 |
VIJAY |
22 |
PGDCA |
8000 |
4 |
SAMEER |
19 |
BCA |
10000 |
Sort On Name /A to Student1
Use Student1
List
Rec# |
NAME |
AGE |
COURSE |
FEES |
1 |
AJAY |
25 |
PGDCA |
8000 |
2 |
RAJESH |
21 |
DCA |
5000 |
3 |
SAMEER |
19 |
BCA |
10000 |
4 |
VIJAY |
22 |
PGDCA |
8000 |
Ex – Use Student
List
Sort On Name /D to Student2
Use Student2
List
Rec# |
NAME |
AGE |
COURSE |
FEES |
1 |
VIJAY |
22 |
PGDCA |
8000 |
2 |
SAMEER |
19 |
BCA |
10000 |
3 |
RAJESH |
21 |
DCA |
5000 |
4 |
AJAY |
25 |
PGDCA |
8000 |
SORTING ON MULTIPLE FIELDS
जब Database File में Sort किये जाने वाले Field में एक जैसे दो या दो से अधिक समान Records होते हैं
तब किसी दूसरे Field का Use उन समान Records की Sorting के लिए किया जाता है
Ex – Use Student
List
Rec# |
NAME |
AGE |
COURSE |
FEES |
1 |
RAJESH |
21 |
DCA |
5000 |
2 |
AJAY |
25 |
PGDCA |
8000 |
3 |
VIJAY |
22 |
PGDCA |
8000 |
4 |
AJAY |
19 |
BCA |
10000 |
Sort On Name,Age to Student2
Use Student2
List
Rec# |
NAME |
AGE |
COURSE |
FEES |
1 |
AJAY |
19 |
BCA |
10000 |
2 |
AJAY |
25 |
PGDCA |
8000 |
3 |
RAJESH |
21 |
DCA |
5000 |
4 |
VIJAY |
22 |
PGDCA |
8000 |
FoxPro Mathematical Commands
FoxPro SET Commands
FoxPro Functions
Click Here To Read What is FoxPro and Commands with Example
Important Question Answer
Click Here for Important Question-Answer – Computer
Click Here for Important Question-Answer – Indian Geography
Click Here for Important Question-Answer – World Geography
Click Here for Important Question-Answer – Indian History
Click Here for Important Question-Answer – Economy
Click Here To Go To Home Page and Get More Knowledge