Sorting in FoxPro with Example

Sorting in FoxPro with ExampleSorting 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

इसी प्रकार की महत्वपूर्ण जानकारी प्राप्त करने के लिए यहाँ Click करके Whats App Channel पर Follow Button को Select कर सकते हैं

 

Leave a Comment

x
Scroll to Top